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