Breakthrough Third Session

Problem

Table: `workout`

| Column Name | Type |
|---|---|
| athlete_id | int |
| distance_km | decimal(5,2) |
| logged_at | datetime |

There is no single-column primary key; `(athlete_id, logged_at)` is unique. Each row is a logged workout for an athlete.

For every athlete, look at their third workout in chronological order. Return that workout only if its `distance_km` is strictly greater than both the athlete's first and second workouts. Output `athlete_id`, the third workout's distance as `breakthrough_distance`, and its timestamp as `breakthrough_at`, ordered by `athlete_id`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns athlete_id, breakthrough_distance, breakthrough_at.

Starter code (SQL)

SELECT *
FROM workout;

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