Back to Editor

Solution: 40. Channels with No Videos in the Dataset

Medium

Problem Detail:

Write a SQL query to find channels that do not have any matching records in the videos table.

Answer SQL Query:

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