Match Counts Between Chess Players

Problem

Table: `match_log`

| Column Name | Type |
|---|---|
| white_id | int |
| black_id | int |
| moves | int |

This table has no primary key. Each row records one chess match: `white_id` played the white pieces, `black_id` played black, and `moves` is how many moves the game lasted. The same two players may meet many times, sometimes swapping colours.

For each **unordered pair** of players who have faced each other, report the number of matches between them and the total number of moves across those matches. The match between A and B is the same pairing as B and A. Output columns `player_a`, `player_b` (with `player_a < player_b`), `matches`, and `total_moves`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns player_a, player_b, matches, total_moves.

Starter code (SQL)

SELECT *
FROM match_log;

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