Routine~13min

The Unverified Vendor

Finance policy is strict: no vendor gets paid until KYC is approved. But during last month's system cutover, the payment gate check was briefly disabled. Five vendors with kyc_status=pending slipped through and received payments totalling ₹7,13,200. One pending vendor (NewBiz Consultants) was correctly blocked — all its invoices are on_hold.

Tables you'll query

vendorsinvoices

What you'll learn

JOINsAggregations & GROUP BY
Investigate this case →