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
Investigate this case →