...

/

Final Project: Build a Game Leaderboard

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. ...