107 804
Assignments Done
100%
Successfully Done
In November 2024
In November 2024
Your physics assignments can be a real challenge, and the due date can be really close — feel free to use our assistance and get the desired result.
Physics
Be sure that math assignments completed by our experts will be error-free and done according to your instructions specified in the submitted order form.
Math
Our experts will gladly share their knowledge and help you with programming projects. Keep up with the world’s newest programming trends.
Programming
Answer to Question #176179 in Databases | SQL | Oracle | MS Access for ghyuar
Question #176179
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
Expert's answer
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;
-
![Help me with my assignment!]()
Who Can Help Me with My Assignment
There are three certainties in this world: Death, Taxes and Homework Assignments. No matter where you study, and no matter…
-
![How to finish assignment]()
How to Finish Assignments When You Can’t
Crunch time is coming, deadlines need to be met, essays need to be submitted, and tests should be studied for.…
-
![Math Exams Study]()
How to Effectively Study for a Math Test
Numbers and figures are an essential part of our world, necessary for almost everything we do every day. As important…
Comments
SELECT video.name AS video_name, video.no_of_views AS no_of_views FROM video_genre INNER JOIN video ON video_genre.video_id = video.video_id WHERE video_genre.genre_id IN (201, 202) GROUP BY video.name ORDER BY no_of_views DESC, video_name ASC LIMIT 5;
Leave a comment