Back to Editor

Solution: 39. Videos from Channels with More Than 1 Million Subscribers

Medium

Problem Detail:

Write a SQL query to list videos that belong to channels having more than 1 million subscribers.

Answer SQL Query:

SELECT v.video_id, v.title, c.channel_name, c.subscriber_count
FROM videos v
JOIN channels c
  ON v.channel_id = c.channel_id
WHERE c.subscriber_count > 1000000;
You can easily copy this solution, switch back to your editor tab, paste it, and run the SQL!