Answer to Question #284069 in Databases | SQL | Oracle | MS Access for Lovely

Question

11. Get all the channel_ids that uploaded at least one video in "AI/ML" or "Robotics" technologies between 2018 and 2021.

Note:

. Consider all the videos that have any of the technologies mentioned above in their name

• Sort the output in the ascending order of channel_id

Expected Output Format

channel_ld

Answer 1

select ​video_content.channelid
FROM ​quiz.video_content inner join user_details u on quiz.video_id=u.user_id
WHERE ​count(u.user_id) >= 20  AND name like '%DIY%' OR name LIKE '%Robotics%'
 "2018"  AND "2021" GROUP BY video_content.channelid
ORDER ​BY video_content.channelid