Routine~11min

The Wrong Unit of Measure

A product stocked and sold in cartons has 47 purchase orders recorded in "units" instead. The warehouse received cartons regardless, so physical inventory is 12x what the system believes. Over 3,000 units are sitting in the warehouse, untracked.

Tables you'll query

productspurchase_orders

What you'll learn

JOINsAggregations & GROUP BY
Investigate this case →