Tricky~22min

The Gateway Gap

Refund rate is 5.9% — within policy. The payments team says everything is normal. But in the last 30 days, hundreds of refunds were initiated with the same reason: "delivery confirmation failed — auto refund." That's not a customer behaviour. That's a system behaviour. Find the pattern.

Tables you'll query

payment_gatewaystransactionsrefunds

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →