Routine~11min

The Negative Stock

Warehouse manager flagged something in the weekly stock report — 9 SKUs are showing negative on-hand quantities. Stock can't go negative physically. We need to know which products and by how much.

Tables you'll query

productsinventory_adjustments

What you'll learn

Aggregations & GROUP BY
Investigate this case →