Third Fastest Marathon Time

Problem

A race organiser stores each runner's finishing time in whole minutes.

Table: `race_finishes`

| Column | Type |
|---------------|------|
| runner_id | int |
| finish_minutes| int |

`runner_id` is the primary key. Faster runners have a **smaller** `finish_minutes`.

Write a query that reports the **3rd fastest distinct** finishing time, aliased as `third_fastest`. (The 3rd fastest is the 3rd smallest distinct value.)

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns third_fastest.

Starter code (SQL)

SELECT *
FROM race_finishes;

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