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
1
Expert's answer
2021-03-27T18:47:28-0400
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
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
APPROVED BY CLIENTS
Finding a professional expert in "partial differential equations" in the advanced level is difficult.
You can find this expert in "Assignmentexpert.com" with confidence.
Exceptional experts! I appreciate your help. God bless you!
Comments
Leave a comment