Routine~13min
The Stuck Shipment
38 customer orders have been "in transit" for over 45 days. Same carrier, all of them. The carrier's tracking portal stopped updating 6 weeks ago. The packages are missing.
Tables you'll query
carriersshipments
What you'll learn
Date & Time FunctionsAggregations & GROUP BY