SQLQuokka
Start practicing
QuestionsLearnSandboxFeaturesRoadmapFAQ

Top Rater and Top Movie

Unsolved

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.

SQL Query Editor (Ctrl+Enter to run)
0 characters · Valid
Canonical Solution Official

Official Solution is Hidden

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Community Q&A & Discussion

Ask questions, share alternate queries, and explore solutions

0 comments
Asked By:
Classic pattern · not tied to a specific company

Submission History

Your recent query executions and answer checks

Execution Pipeline:
FROM movies
Full source dataset
3 rows total
Ready. Type a query to see live execution.
Clause: Auto-Sync · AlaSQL Engine