SQL Formatter

Messy SQL

Formatted

SELECT u.name,
  u.email,
  COUNT(o.id) 
AS order_count 
FROM users u left 
JOIN orders o 
ON u.id = o.user_id 
WHERE u.active = true 
AND o.created_at > '2024-01-01' 
GROUP BY u.name,
  u.email 
HAVING 
COUNT(o.id) > 5 
ORDER BY order_count desc 
LIMIT 10