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

Question

7. Get all the videos that belong to "Action" genre (genre_id = 201) and have more than 1 lakh views.

Note:

• Sort the output in the ascending order of video_id.

Expected Output Format:

video_id

name

genre id

Answer 1

SELECT vc.id as Video_id ,v.genre_id 
FROM quiz.video_content as vc
group by vc.name,vc.genre_id, vc.id
order by vc.name asc,vc.no_of_views desc