Final Project: Build a Game Leaderboard
Solve the game with custom queries and present insights.
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 score. ...