Last Crate Loaded on the Delivery Van

Problem

Table: `LoadingLine`

```text
+-------------+----------+
| Column | Type |
+-------------+----------+
| crate_id | int |
| label | varchar |
| mass_kg | int |
| load_order | int |
+-------------+----------+
crate_id is the primary key. Crates are loaded onto the van one at a time in
increasing load_order. load_order values are unique.
```

A delivery van can carry at most **1000 kg**. Crates are loaded in `load_order`. As soon as adding the next crate would push the running total above 1000 kg, loading stops and no further crate is loaded.

Return the `label` of the last crate that actually makes it onto the van.

**Example**

Loading in order, the cumulative mass reaches 1000 kg exactly at the third crate, and the fourth would exceed it, so the third crate's label is returned.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns label.

Starter code (SQL)

SELECT *
FROM LoadingLine;

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