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