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

Question

11. Get to top 5 viewed videos which belong to both the genres "Action" (genre_id= 201) and "Comedy" (genre_id= 202).

Note:

. In case, if the no_of_views are same, then sort the output in the ascending order of video_name.

Expected Output Format

video_name

no_of views

Answer 1

select vc.name,vc.no_of_views
from quiz.video as v,quiz.video_content as vc
where v.genre_id=201 and v.genre_id=202
limit  5;