Complex~37min

The Vendor Ghost

₹85 lakh paid to TechParts Ltd over roughly 4.5 months. Purchase orders raised, payments cleared. But no delivery records exist and inventory never received the goods. Find the money.

Tables you'll query

vendorspurchase_orderspaymentsdeliveriesinventory_receipts

What you'll learn

JOINsSubqueriesAggregations & GROUP BYNULL Handling
Investigate this case →