A streaming service's review team wants two facts in one column called results. The first row is the name of the user who rated the most movies overall; if several users tie, choose the alphabetically smallest name. The second row is the title of the movie with the highest average rating among ratings created in February 2025; if several movies tie, choose the alphabetically smallest title. Write an SQL query that returns a single column, results, with those two rows.
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.