In [1]:
-- AI: "top regions Q1 with YoY"
SELECT region, SUM(amount) AS revenue,
COUNT(DISTINCT customer_id) AS customers
FROM orders WHERE ts >= '2026-01-01'
GROUP BY 1 ORDER BY 2 DESC;
SELECT region, SUM(amount) AS revenue,
COUNT(DISTINCT customer_id) AS customers
FROM orders WHERE ts >= '2026-01-01'
GROUP BY 1 ORDER BY 2 DESC;
✓ 5 rows · 384 ms · 2.1 GB scanned
| region | revenue | customers |
|---|---|---|
| NA-East | $4,128,402 | 38 |
| EMEA | $3,891,015 | 31 |
| NA-West | $3,204,778 | 29 |
| APAC | $2,440,991 | 22 |
| LATAM | $1,108,540 | 12 |