Complex~35min

The Safety Stock That Never Triggers a Reorder

6 product-warehouse combinations dropped below their reorder point in 3 separate weeks over a 10-week window and never once triggered a purchase order — not that week, not before, not after. 4 more combinations also dipped with no PO in the exact breach week, but recovered on their own because a PO was already placed back in week 1, well before the dip.

Tables you'll query

inventory_snapshotspurchase_orders

What you'll learn

CTEs (WITH clause)Window FunctionsDate & Time Functions
Investigate this case →