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