SQLQuokkaSQLQuokkaYouTube Trending Algorithms identify breakout videos that capture audience sentiment through high engagement. Write a SQL query to find videos uploaded in 2024 or 2025 that have accumulated at least 50,000 views and achieved an engagement ratio (`likes / views * 100`) of 9.00% or higher. For each qualifying video, output the `video_id`, `channel_name`, `video_title`, `views`, `likes`, and `like_ratio` (rounded to 2 decimal places). Order the results by `like_ratio` in descending order, breaking ties by `views` in descending order.
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.