New
Anomalies in login traffic· Apr 28
Show me total Q1 revenue by region, with the top 3 channels driving each region.
TU
Q1 totals by region: North America led at $1.25M (Direct, Referral, Paid), Europe at $982K (Direct, Organic, Email), Asia Pacific at $754K (Paid, Direct, Referral), Latin America at $313K (Organic, Direct, Paid). North America accounted for ~37% of total Q1 sales.
Q1 sales by region
Query workbenchSQL · Production Postgres
query.sqlSQLread-only role
-- Q1 sales by region
SELECT region, SUM(amount) AS total_revenue
FROM orders
WHERE created_at >= '2026-01-01'
  AND created_at < '2026-04-01'
GROUP BY region
ORDER BY total_revenue DESC;
Tip — ⌘ Ito ask AI to fix or explain
regiontotal_revenue
North America1,250,000
Europe982,000
Asia Pacific754,000
Latin America313,000
Success·4 rows · 287msLast run 2m ago · Production Postgres
0 kept