Routine~12min
The Overloaded Location
Three warehouse bin locations show dozens of inventory items assigned to them — but their capacity is listed as 0. They were decommissioned but never removed from the WMS. A migration job reassigned items to them without checking capacity. The items are physically elsewhere; the system doesn't know where.
Tables you'll query
bin_locationsinventory
What you'll learn
JOINsAggregations & GROUP BY