Project: Build a Game Leaderboard
Explore how to build a game leaderboard by applying SQL skills like JOINs, grouping, and aggregation. Learn to combine player and score data, identify top scorers, calculate averages, and find inactive players. This lesson reinforces real-world query patterns used in analytics and dashboards.
Congratulations, you’ve learned to explore, filter, join, group, and summarize data like a pro. Now it’s your turn to apply your knowledge and solve the real-world game.
Game leaderboard
In this project, you’ll analyze data from a game leaderboard using SQL. You’ll work with two related tables:
The players table
ID | Name | Level |
1 | Ali | 5 |
2 | Fatima | 7 |
3 | Jon | 4 |
4 | Lina | 6 |
5 | Dan | 3 |
The scores table
Player ID | Game | Points |
1 | Puzzle Quest | 120 |
2 | Puzzle Quest | 150 |
3 | Speed Run | 180 |
1 | Speed Run | 140 |
2 | Speed Run | 130 |
4 | Puzzle Quest | 160 |
Let’s solve some real-world problems using this data.
1. Top 3 scorers across all games
Goal: List the top 3 players based on their total ...