Answer to Question #223639 in Databases | SQL | Oracle | MS Access for Siva

Question

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 contains 14 rows

...

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

Answer 1

SELECT DISTINCT(genre_id),genre
FROM Video
WHERE genre="Comedy" or genre="Action" or genre="Thriller" or genre="scifi";