Back to Editor

Solution: 25. Channels with More Than 1000 Videos

Medium

Problem Detail:

Write a SQL query to find channels having more than 1000 videos in the dataset.

Answer SQL Query:

SELECT channel_id, COUNT(*) AS total_videos
FROM videos
GROUP BY channel_id
HAVING COUNT(*) > 1000
ORDER BY total_videos DESC;
You can easily copy this solution, switch back to your editor tab, paste it, and run the SQL!