Tricky~22min

The Double Charge

Zenith IT Services is a reliable vendor — 4 years, never an issue. Finance signed off on 41 "revised" invoices last quarter. The originals were also paid. Both sets are in the payment table. ₹1.48 Cr went out twice.

Tables you'll query

vendorsinvoicespayments

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →