Tricky~21min

The Generous Refund

Clothing refunds are averaging ₹347 more than the order value. Finance thought it was a data entry glitch. It isn't. Someone is consistently approving refunds that include a charge customers were never billed for.

Tables you'll query

ordersrefunds

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →