Tournament Winners
ASKED IN INTERVIEWRiot Games
Problem Statement
Identify the player(s) with the most points for every tournament.
Rules:
- Output columns: tournament_name, winner_name, total_points.
- Handle ties by returning all top scorers for that tournament.
- Sort by tournament_name ASC.
Tests your understanding of
Window Functions, RANK, Aggregation and Joins
Input Tables
tournaments
| tournament_id(INTEGER) | name(VARCHAR) |
|---|---|
| 1 | Worlds 2025 |
| 2 | MSI 2025 |
players
| player_id(INTEGER) | display_name(VARCHAR) |
|---|---|
| 501 | Faker |
| 502 | Caps |
| 503 | Chovy |
match_results
| match_id(INTEGER) | tournament_id(INTEGER) | player_id(INTEGER) | points(INTEGER) |
|---|---|---|---|
| 1 | 1 | 501 | 10 |
| 2 | 1 | 501 | 15 |
| 3 | 1 | 502 | 20 |
| 4 | 2 | 503 | 30 |
Expected Output
| tournament_name(VARCHAR) | winner_name(VARCHAR) | total_points(INTEGER) |
|---|---|---|
| MSI 2025 | Chovy | 30 |
| Worlds 2025 | Faker | 25 |
Tags
HardASKED IN INTERVIEWWindow FunctionsRANKAggregationJoins
25-35 min
44%