Answer to Question #284145 in Databases | SQL | Oracle | MS Access for Lovely

Question

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

Answer 1

SELECT DISTINCT channel_id, channel_name, subscribers_per_month
WHERE channel_name LIKE "Taylor Swift",

FROM  video WHERE year = "2018" ORDER BY channel_id, ASC;