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