-- July's failed payments from the two pilot regions, biggest first.

SELECT id, region, status, amount

FROM payments

WHERE strftime('%Y-%m', created_at) = '2026-07'

  AND status = 'failed'

  AND region = 'EU'

  OR region = 'UK'

ORDER BY amount DESC;