Answer to Question #234637 in Databases | SQL | Oracle | MS Access for Suraj

Question

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.

Expected Output Format:

channel_id channel_name no_of_subscribers

Answer 1

SELECT DISTINCT channel_id, channel_name, no_of_subscribers
FROM  video WHERE year = "2018" ORDER BY channel_id DESC limit 10;.