Routine~14min

The Refund Bigger Than The Order

Finance flagged 5 orders where the total refunded is more than the customer ever paid. Support agents were re-processing refund requests for customers who called in twice about the same issue, and the tool never checked whether a refund had already gone through. One ₹18,500 refund looks alarming on its own, but that one's fine — the order was ₹22,000.

Tables you'll query

ordersrefunds

What you'll learn

Aggregations & GROUP BYJOINs
Investigate this case →