Answer to Question #171195 in Databases | SQL | Oracle | MS Access for srikanth

Question

Get all the recent movie trailers that have more than 1 lakh views.

Note:
Consider the videos that have "trailer" in theirnameas trailers.
Sort the output in the descending order ofno_of_viewsandpublished_datetime
Expected Output Format
name	channel_id	no_of_views	published_datetime
...      ...           ...           ....

Answer 1

SELECT name ,channelid, no_of_views,published_datetime FROM quiz.video_content where no_of_views>100000 and name like '%trailer%';