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