-- Основний запит
WITH successful_transactions AS (
  SELECT user_id, SUM(amount) AS total_spend
  FROM transactions
  WHERE status = 'success'
  GROUP BY user_id
),
user_with_region AS (
  SELECT st.user_id, st.total_spend, u.region_id
  FROM successful_transactions st
  JOIN users u ON st.user_id = u.user_id
),
region_avg AS (
  SELECT region_id, AVG(total_spend) AS avg_region_spend
  FROM user_with_region
  GROUP BY region_id
),
above_avg_users AS (
  SELECT uwr.*, ra.avg_region_spend
  FROM user_with_region uwr
  JOIN region_avg ra ON uwr.region_id = ra.region_id
  WHERE uwr.total_spend > ra.avg_region_spend
)
SELECT *
FROM above_avg_users
ORDER BY region_id, total_spend DESC;