Which regions are driving your revenue — and which are lagging?

WITH quarters AS (
  SELECT
    region,
    SUM(CASE
      WHEN order_date >= DATE_TRUNC('quarter', CURRENT_DATE)
       AND order_date <  DATE_TRUNC('quarter', CURRENT_DATE) + INTERVAL '3 months'
      THEN total_amount ELSE 0
    END)                             AS current_quarter,
    SUM(CASE
      WHEN order_date >= DATE_TRUNC('quarter', CURRENT_DATE) - INTERVAL '3 months'
       AND order_date <  DATE_TRUNC('quarter', CURRENT_DATE)
      THEN total_amount ELSE 0
    END)                             AS prior_quarter
  FROM orders
  WHERE order_date >= DATE_TRUNC('quarter', CURRENT_DATE) - INTERVAL '3 months'
  GROUP BY region
)
SELECT
  region,
  ROUND(current_quarter, 2)         AS current_q_revenue,
  ROUND(prior_quarter, 2)           AS prior_q_revenue,
  ROUND(current_quarter - prior_quarter, 2) AS change,
  ROUND(
    (current_quarter - prior_quarter)
    / NULLIF(prior_quarter, 0) * 100, 2
  )                                 AS pct_change
FROM quarters
ORDER BY current_quarter DESC