Complex~37min
Zero Net
Inventory accuracy is 99.1% across the warehouse. The electronics team lead is proud of it. The external auditors flagged "unusual adjustment patterns" in their exit interview. Nobody followed up.
Tables you'll query
sku_categoriesskusinventory_countsstock_adjustments
What you'll learn
CTEs (WITH clause)Window FunctionsAggregations & GROUP BYJOINs