New
Anomalies in login traffic· 6d ago
3 of 3 sources·Main + 4 specialists routed
Show me total Q1 revenue by region, with the top 3 channels driving each region.
TU
Maindelegated toResearchViz
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
4 rows · 287msproduction-postgres / orders
SQL · executed by Researcher
SELECT region, channel, SUM(amount) AS total
FROM orders
WHERE quarter = 'Q1'
GROUP BY region, channel
ORDER BY region, total DESC;
Sources: production-postgres orders
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