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
... ... ... ....
SELECT name ,channelid, no_of_views,published_datetime FROM quiz.video_content where no_of_views>100000 and name like '%trailer%';
Comments
Leave a comment