Finance & FP&AMedium
Identify duplicate invoices — same vendor, same amount, within 7 days.
Seen at: Stripe · Brex · Goldman Sachs · JPMorgan
AP noticed several duplicate payments last quarter. Write SQL against an ap_invoices table (invoice_id, vendor_id, amount, invoice_date) to flag likely duplicates: same vendor, same amount, invoice dates within 7 days of each other.
Draft your answer
Saved to this browser only. Try it before you peek at the model answer.
Stuck? Peek at a hint
Reveals the model answer and the self-score rubric.