⌘ Enter
Ln 5, Col 23
1
2
3
4
5
6
7
8
9
10
SELECT
  u.id,
  u.name,
  u.email,
  COUNT(o.id) AS total_orders,
  SUM(o.total) AS revenue
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE o.created_at >= '2026-01-01'
GROUP BY u.id, u.name, u.email
247 rows • 0.034s
id name email total_orders revenue
1 Sarah Chen sarah.chen@email.com 47 $12,847.50
2 Marcus Johnson m.johnson@company.io 38 $9,234.00
3 Emily Williams emily.w@startup.co 52 $15,672.25
4 David Kim dkim@enterprise.net 29 $7,891.00
5 Lisa Anderson l.anderson@firm.com 61 $18,445.75
6 James Wilson jwilson@tech.io 33 $8,567.50
7 Maria Garcia m.garcia@agency.co 44 $11,234.00