SQLQuokkaSQLQuokkaYouTube Creator Analytics wants to detect individual 'breakout' videos that dominate their channel's traffic by accounting for at least 50.0% of the channel's total lifetime views. Write a SQL query returning the `channel_name`, video `title`, `views`, and `view_share_pct` (the video's views divided by the total views of all videos on that channel, multiplied by 100 and rounded to 2 decimal places). Order the results by `view_share_pct` in descending order, resolving ties by `channel_name` ascending.
Loading…
Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.
Ask questions, share alternate queries, and explore solutions
Your recent query executions and answer checks
This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.