Each Athlete's Best Event

Problem

A decathlon league records the points an athlete scored in each event they competed in.

Table: result
+-----------+------+
| Column | Type |
+-----------+------+
| athlete_id| int |
| event_id | int |
| points | int |
+-----------+------+
(athlete_id, event_id) is the primary key. Each row is the points an athlete earned in one event.

Write a solution to find, for each athlete, the event in which they scored their highest points, along with that points value. If an athlete's top points are tied across multiple events, pick the event with the smallest event_id. Return columns athlete_id, event_id, and points, ordered by athlete_id ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns athlete_id, event_id, points.

Starter code (SQL)

SELECT *
FROM result;

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