SQL Formatter

Pretty-print + minify SQL

296 chars

SQL input

Formatted

  SELECT
  u.id,
  u.email,
  COUNT(o.id
  ) AS order_count,
  SUM(o.total_cents
)/100.0 AS revenue
FROM  users u
LEFT JOIN  orders o
ON  o.user_id = u.id AND o.status = 'paid'
WHERE  u.created_at > '2024-01-01' AND u.deleted_at IS NULL
GROUP BY  u.id, u.email
  HAVING  COUNT(o.id
) > 5
ORDER BY  revenue DESC
LIMIT  50;

Minified · 296 chars

select u.id, u.email, count(o.id) as order_count, sum(o.total_cents)/100.0 as revenue from users u left join orders o on o.user_id = u.id and o.status = 'paid' where u.created_at > '2024-01-01' and u.deleted_at is null group by u.id, u.email having count(o.id) > 5 order by revenue desc limit 50;