Chess Club Standings

Problem

Table: `Players`

```text
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| player_id | int |
| player_name | varchar |
+-------------+---------+
player_id is the primary key for this table.
```

Table: `Games`

```text
+-------------+------+
| Column Name | Type |
+-------------+------+
| white_id | int |
| black_id | int |
| white_score | int |
| black_score | int |
+-------------+------+
(white_id, black_id) is the primary key for this table.
Each row is one game: who played White, who played Black, and the rounds each side won.
```

Write a solution to build the club standings. For each player report:
- `player_name`
- `games_played`
- `league_points`: Win = 3, Draw = 1, Loss = 0
- `rounds_for`: total rounds the player won
- `rounds_against`: total rounds the player conceded
- `rounds_diff`: rounds_for minus rounds_against

Return the result table ordered by `league_points` DESC, then `rounds_diff` DESC, then `player_name` ASC.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns player_name, games_played, league_points, rounds_for, rounds_against, rounds_diff.

Starter code (SQL)

SELECT *
FROM Players;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium