Heaviest Parcel Shipped Each Day

Problem

Table: `Shipments`

```text
+-------------+----------+
| Column Name | Type |
+-------------+----------+
| parcel_id | int |
| ship_ts | datetime |
| weight_kg | int |
+-------------+----------+
parcel_id is the primary key for this table.
Each row describes one parcel: when it left the depot and how much it weighed.
```

A logistics depot wants to flag the heaviest parcel it sent out on each calendar day. If two or more parcels on the same day tie for the highest weight, all of them should be flagged.

Write a solution to report the `parcel_id` of the heaviest parcel(s) shipped on each day.

Return the result table ordered by `parcel_id` in ascending order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns parcel_id.

Starter code (SQL)

SELECT *
FROM Shipments;

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