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
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;
Comments
Leave a comment