Tricky~20min
The Split Invoice
Accounts payable processed 31 invoices from Nexus Infra Solutions in Q3 — all for "infrastructure work". All approved at manager level. CFO never saw any of them. Pull the amounts.
Tables you'll query
vendorsinvoices
What you'll learn
SubqueriesAggregations & GROUP BYDate & Time Functions