Back to Editor

Solution: 37. Videos Belonging to Indian Channels

Medium

Problem Detail:

Write a SQL query to find all videos whose channels belong to India.

Answer SQL Query:

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