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