Tricky~23min

The Cold Chain Break

5 shipments of frozen berries logged 9+ straight temperature readings above the 8°C safe threshold — over 2 hours of sustained cold-chain failure — yet were still marked delivered_ok. Ten other shipments had a reading or two spike above 8°C too, but that's just normal dock loading noise under 30 minutes.

Tables you'll query

shipmentstemperature_logs

What you'll learn

Aggregations & GROUP BYJOINs
Investigate this case →