Routine~12min

The Phantom Supplier

Eight approved purchase orders totalling ₹4,21,750 reference supplier codes that don't exist in the suppliers table. A junior buyer manually typed them into the ERP during a system cutover, making typos that created phantom codes. There's no matching contract, no KYC, no way to know who gets paid.

Tables you'll query

supplierspurchase_orders

What you'll learn

JOINsAggregations & GROUP BY
Investigate this case →