Search & Filtering
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.
In a university, there is a certain system of credits. Each of student is given a ‘credit limit’ which specifies the maximum credits of a subject they can take. A student can take any number of subjects which are under his/her credit limit.
There are N students and K subjects.Each subject has a specified number of credits .when student choose a subject ,it becomes a (student,subject)pair.
Find the maximum number of possible(subject,student)pairs for the given credit limits and subject credit requirements.
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
Create a frame. Place two textboxes in the frame using any appropriate layout. Then place four buttons with the button title SUM, AVERAGE, MAXIMUM and MINIMUM. If the user put two numeric values in the text fields and click any of the button, then a corresponding calculation ( sum, average, maximum or minimum) of the two inputs should be shown in a JOptionPane Message Dialogue popup. If the user mistakenly provides any non numerical values in any of the textboxes then a message "Input should be numerical. Please try again" should be shown in a JOptionPane Message Dialogue popup.
- 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]
How can you know which program to use for,do while,if else,if,while statements for
