28. Channels with Very High Video Count
Solution ↗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 channels where video_count is greater than 100000.
Hint
Tip: Simple numeric filter on video_count.
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 | video_count | +--------------+------------+ | | | +--------------+------------+
Explanation:
The sample may produce an empty result if no row satisfies the threshold.