Project: Build a Game Leaderboard
Apply your SQL skills to build a game leaderboard by working with related tables using joins. Discover how to calculate top scorers, average scores per game, and identify players without scores through filtering and aggregation techniques. This project reinforces essential SQL concepts used in real-world data analysis.
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.