Solution: 47. Top 3 Most Viewed Videos Within Each Channel

WITH ranked_videos AS (
    SELECT c.channel_name,
           v.video_id,
           v.title,
           s.view_count,
           ROW_NUMBER() OVER (
               PARTITION BY v.channel_id
               ORDER BY s.view_count DESC
           ) AS rn
    FROM channels c
    JOIN videos v
      ON c.channel_id = v.channel_id
    JOIN video_stats s
      ON v.video_id = s.video_id
)
SELECT channel_name, video_id, title, view_count
FROM ranked_videos
WHERE rn <= 3;