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