Databases | SQL | Oracle | MS Access Answers

3. Get the number of subscribers for each channel.

Note:

• Sort the output in the descending order of no_of_subscribers, and then in the ascending order of channel_name.

If there are no subscribers for a channel is 0, then keep the no_of_subscribers as 0.

Expected Output Format:

channel Id

channel_name

No_of_subscribers

2. Get the number of users who possitively engaged with at least one video of Disney

Channel (channel_id = 352).

Note:

. Consider possitive engagement as LIKE for a video uploaded by Disney channel.

Expected Output Format:

no_of_users reached

1. Get the top 10 channels for which more number of users are subscribed in the year 2018.

Note:

In case, if the no_of_subscribers are same, then sort the output in the ascending order of channel_name.

15. Insights about users:

Get the geographic distribution of Taylor Swift channel (channel_id = 399) subscribers.

Note:

• Geographic distribution: Number of Taylor Swift subscribers present in each country. Ignore the countries where no_of_subscribers is 0.

• Order the result in the ascending order of the country name.

Expected Output Format

country

no_of_subscribers

14. Get the total number of countries where the subscribers of the Taylor Swift channel (channel_id = 399) are present.

Expected Output Format

country_count

Get the total number of countries where the users of the platform are present.

Expected Output Format

country count

12. Get the total number of users subscribed for the channel "Tyler Oakley" (channel_id = 376) in the year 2018.

Expected Output Format

no_of_subscribers

10. Between 2010 & 2020, find the number of videos released in each of the below genres.

Note:

genre_ids: 201, 202, 204, 205, 206, 207

• Sort the output in the descending order of no_of_videos, and then in the ascending order of genre_id.

Expected Output Format:

genre ld

no_of_videos

9. Find the number of videos published between the years 2010 & 2016.

Note:

• Sort the output in the ascending order of the year

Keep the year in the integer format

Expected Output Format:

year

no_of_videos

8. Get all the Indian users details whose age is below 30 years and liked the video (video_id=1011) in the year 2020.

Note:

Consider the name of the country as "INDIA"

. Consider reaction_type LIKE as liked.

Sort the output in the ascending order of name.

Expected Output Format:

name

gender

age

country