Get the number of subscribers for each channel SQL Query

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 …. …. …. Solution

Categories SQL