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