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

Question

7. Get all the channels that published at least 5 videos in the year 2018.

Note:

Sort the output in the ascending order of channel_id.

Expected Output Format

channel d

channel_name

no of videos

Answer 1

SELECT DISTINCT channel_id, channel_name, no_of_videos
FROM  video WHERE year = "2018" 
ORDER BY no_of_videos DESC limit 5;.