Last Person to Board the Bus

Problem

**[Classic — asked at multiple companies including Uber, DoorDash]**

People queue to board a bus with a **1 000 kg weight limit**. They board in
`turn` order (turn=1 first). Each person boards only if the cumulative weight
does NOT exceed 1 000 kg.

Find the `person_name` of the **last person who can board** without the
total exceeding 1 000 kg.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns person_name.

Starter code (SQL)

SELECT *
FROM queue;

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