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 ofvideo_id
Expected Output Format
video_id
Please help
SELECT distinct video_id FROM video
where genre_id IN
(
201,
202,
203,
211
)
order by video_id desc;
Comments
Leave a comment