In April 2025
Search & Filtering
13. Best time to upload a comedy video:
DunkFest channel is planning to upload a video in the "COMEDY" genre Give the channel the best suitable hour of the day when users positively engage more with comedy videos.
Note:
• Consider positive engagement as LIKE for the videos in the "COMEDY" genre_type.
. Consider reaction_type LIKE as liked.
. Return the hour in the integer format
Expected Output Format
hour of engagement
no of Likes
12. Get the top 5 viewed videos that belong to the "GAMING" genre_type.
Note:
• Sort the output in the descending order of no_of_views, and then in the ascending order of video_name.
Expected Output Format
video_name
no_of_views
11. Get to top 5 viewed videos which belong to both the genres "Action" (genre_id= 201) and "Comedy" (genre_id= 202).
Note:
. In case, if the no_of_views are same, then sort the output in the ascending order of video_name.
Expected Output Format
video_name
no_of views
10. Get all the distinct user_ids who liked at least one video uploaded by Android Authority Channel (channel_id = 364) but didn't like the video uploaded by Tech savvy channel with video_id=1005.
Note:
. Consider reaction_type LIKE as liked
• Sort the output in the ascending order of user_id
Expected Output Format
user Is
Get all the videos that have more than the average number of views,
Note:
• Sort the output in the ascending order of name.
Expected Output Format
name
no_of_views
How many times each user has engaged with the videos of "News for you" channel (id = 366).
Note:
. Consider engagement as LIKE or DISLIKE for a video uploaded by News for you channel.
• Ignore the users who did not engage with the channel at least once.
• Sort the output in the descending order of no_of_reactions, and then in the ascending order of user_id
Expected Output Format
user_id
No_of_reactions
7. Get all the channels that published at least 5 videos in the year 2018.
Note:
Sort the output in the ascending order of channel_id.
Expected Output Format
channel d
channel_name
no of videos
6. Get the number of videos published by each channel.
Note:
• If a channel did not upload any video, keep the no_of_videos as 0.
• Sort the output in the ascending order of channel_name.
Expected Output Format
channel_name
no of videos
5. Get the number of users subscribed for the "Taylor Swift" channel in every month in the year 2018.
Note:
• Sort the output in the ascending order of month_in_2018.
• Ignore the months that have subscribers_per_month as 0.
Expected Output Format
month in 2018
subscribers_per_month
4. Get the number of videos uploaded by the "News for you" channel in the year in 2018.
Expected Output Format
no of videos
