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

Question

10. Between 2010 & 2020, find the number of videos released in each of the below genres.

Note:

genre_ids: 201, 202, 204, 205, 206, 207

• Sort the output in the descending order of no_of_videos, and then in the ascending order of genre_id.

Expected Output Format:

genre ld

no_of_videos

Answer 1

select count(video_id)
from videos
where year between 2010 and 2020, genre_id in (201,202,204,205,206,207)
order ​by genre_id asc, no_of_videos desc;