Databases | SQL | Oracle | MS Access Answers

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