22. Top 10 Channels by Subscribers

Solution ↗

Medium

Tables: channels

+-------------------------+-------------+
| Column Name             | Type        |
+-------------------------+-------------+
| channel_id              | varchar     |
| channel_name            | varchar     |
| subscriber_count        | bigint      |
| view_count              | bigint      |
+-------------------------+-------------+
channels contains one row per YouTube channel.
channel_id is the primary key for this table.

Write a SQL query to find the top 10 channels with the highest subscriber_count.

Hint

Tip: Sort by subscriber_count descending.

Input:

channels table:
+------------+------------------+------------------+------------+
| channel_id | channel_name     | subscriber_count | view_count |
+------------+------------------+------------------+------------+
| C101       | Alpha Tech       | 2500000          | 92000000   |
| C102       | Data With Mira   | 1800000          | 71000000   |
| C103       | SQL Zone         | 950000           | 40000000   |
+------------+------------------+------------------+------------+

Output:

Output:
+----------------+------------------+
| channel_name   | subscriber_count |
+----------------+------------------+
| Alpha Tech     | 2500000          |
| Data With Mira | 1800000          |
| SQL Zone       | 950000           |
+----------------+------------------+

Explanation:

Channels are ranked from highest subscribers to lowest.