Programming & Computer Science Answers

This is the code for Getting all the channel_ids that uploaded at least one video in "AI/ML" or "Robotics" technologies between 2018 and 2021.

SELECT

DISTINCT channel_id

FROM

video

WHERE

video_id >= 1

AND name LIKE '%AI/ML%'

OR name LIKE '%Robotics%'

AND strftime('%Y', published_datetime) BETWEEN "2018"

AND "2021"

GROUP BY

channel_id

ORDER BY

channel_id ASC;

Output Table:

channel_id 351 353 364 365 377

But,

How can I Get all the channel_ids that uploaded at least 20 videos in "AI/ML", "Cyber Security", "Data Science" or "Robotics" technologies between 2018 and 2021.

Example: If a channel publishes 5 videos in AI/ML, 10 videos in Cyber Security and 5 videos in Data Science, consider the channel

the table data is very huge so, I cant send the complete table data.

please help me.

Write algorithms for

• Linear Search
• Binary Search
• Bubble Sort
• Quick Sort

Python program to filter even values from list using lambda function

Create Employee class with some attributes and method

1. Your task is to implement the function definition of the cheerUp() function. The cheerUp() function should update the values passed by multiplying each of them by 3.

1. Given a text file contains the name and gender of students, read the file and store the names and genders in a list.

2. Count how many male and female in the list.

3 Store the names of male and female in two different lists.

text file

name,gender

Alice,f

Bruce,m

Cloud,m

Darren,m

Eidy,f

Flower,f

Guile,m

Honda,m

Ilhamah,f

Judy,f

Kennedy,m

Laisy,f

1. Given the scores of students for Mathematics, English and Science, calculate the average score of each student and store it in a list.

2. Write the names, scores of each subject and average scores into a text file or csv file.

Code:

names = ['Zendaya', 'Yaacob', 'Xander', 'Willy',

     'Vega', 'Umar', 'Takata', 'Sheena', 'Rhina', 'Queen']

math = [67, 73, 71, 11, 51, 46, 29, 51, 66, 25]

english = [87, 48, 93, 41, 69, 43, 0, 17, 78, 74]

science = [73, 71, 17, 81, 8, 33, 39, 33, 17, 93]

Suppose that you have a computer with a memory unit of 24 bits per word. In this 

computer, the assembly program’s instruction set consists of 198 different operations. 

All instructions have an operation code part (opcode) and an address part (allowing for 

only one address). Each instruction is stored in one word of memory.

a. How many bits are needed for the opcode?

b. How many bits are left for the address part of the instruction?

c. How many additional instructions could be added to this instruction set without 

exceeding the assigned number of bits? Discuss and show your calculations.

d. What is the largest unsigned binary number that the address can hold?

Write a program in C++ that ask the user to type a value and check whether it is prime or not.

Write a C++ program that prints on the screen following diamond shape with given series of numbers.