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