Databases | SQL | Oracle | MS Access Answers

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

7. Get all the videos that belong to "Action" genre (genre_id = 201) and have more than 1 lakh views.

Note:

• Sort the output in the ascending order of video_id.

Expected Output Format:

video_id

name

genre id

6. Get all the unique channels that published review videos.

Note:

You can consider the videos which contain "review" in name as review videos.

Sort the output in the ascending order of channel_name.

Expected Output Format:

channel_name

4. Get all distinct channels which published music videos before 2016.

Note:

• You can consider the videos which contain "music" in name as music videos.

• Sort the output in the ascending order of chanel_name.

Expected Output Format:

channel_name

3. Get all the music videos released before the year 2016.

Note:

• You can consider the videos which contain "music" in name as music videos.

. Get the year in the integer format

• Sort the output in the descending order of year, and then in the ascending order of name.

Expected Output Format:

name

no_of_views

year

1. Fetch the top 10 videos having more number of views.

Note:

Sort the output in the descending order of no_of_views, and then in the ascending order of name.

Expected Output Format:

name

no_of_views

11. Get all the channel_ids that uploaded at least one video in "AI/ML" or "Robotics" technologies between 2018 and 2021.

Note:

. Consider all the videos that have any of the technologies mentioned above in their name

• Sort the output in the ascending order of channel_id

Expected Output Format

channel_ld