Answer to Question #284283 in Databases | SQL | Oracle | MS Access for swsq

Question

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

Output Table:

channel_id
    351
    353
    364
    365
    377

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 ASC;