Routine~15min
The Vanishing Inventory
Five products show zero stock in the system. The warehouse team insists they're physically there. The system and reality disagree. Find which record is lying.
Tables you'll query
inventoryinventory_adjustmentsproductsphysical_counts
What you'll learn
CASE StatementsSELECT & FilteringJOINs