Databases | SQL | Oracle | MS Access Answers

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

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