Tricky~20min
The Carrier Blindspot
Ops dashboard shows 3.4-day average delivery time — within SLA. Customer support tickets about late orders are up 340% over the last 6 weeks. Ops says the metrics look fine. Either the customers are wrong or the metrics are. One of them is.
Tables you'll query
carriersordersshipments
What you'll learn
SubqueriesJOINsAggregations & GROUP BY