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
Investigate this case →