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

Question

12. Get the top 5 viewed videos that belong to the "GAMING" genre_type.

Note:

• Sort the output in the descending order of no_of_views, and then in the ascending order of video_name.

Expected Output Format

video_name

no_of_views

Answer 1

SELECT vc.name as Video_name,vc.no_of_views
FROM quiz.video_content as vc
group by vc.name,vc.no_of_views order by 
vc.name asc,vc.no_of_views desc limit 0,5