Get the distinct ids of videos that belong to the following genres.
genre_id genre
201 Comedy
202 Action
203 Thriller
211 Scifi
Note:
Sort the output in the descending order of
video_id
Expected Output Format
video_id
...
genre_id genre_type
201 ACTION
202 COMEDY
203 THRILLER
204 ROMANTIC
205 TECHNICAL
206 HEALTH CARE
207 GAMING
208 MUSIC VIDEOS
209 TEASER
210 INSPIRATIONAL
211 SCI-FI
SELECT distinct genre_id as video_id FROM quiz.video;
SELECT distinct genre_id as video_id FROM quiz.video order by genre_id desc;
Comments
Leave a comment