SQL Formatter

SELECT
  u.id,
  u.name,
  u.email,
  COUNT(o.id) AS order_count,
  SUM(o.total_amount) AS revenue
FROM users u
LEFT JOIN orders o
  ON o.user_id = u.id
WHERE u.active = TRUE
  AND o.created_at >= '2026-01-01'
GROUP BY u.id,
  u.name,
  u.email
HAVING COUNT(o.id) > 5
ORDER BY order_count DESC,
  revenue DESC
LIMIT 20;