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