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

Question #284132

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


1
Expert's answer
2022-01-15T09:18:27-0500
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;

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS