Tricky~22min
The Shrink Report
Warehouse 3 reports 11.8% inventory shrinkage. Every other warehouse is under 3%. Management wants to fire the warehouse team. But there's an annual external audit buried in the data. Check what the auditors found.
Tables you'll query
warehousescycle_countsannual_audit
What you'll learn
SubqueriesJOINsAggregations & GROUP BY