SQL Formatter

SELECT u.id,
u.name,
u.email,
count(o.id) AS order_count,
sum(o.total) AS total_spent
FROM users u LEFT
JOIN orders o
ON u.id = o.user_id
WHERE u.created_at >= '2026-01-01'
AND u.status = 'active'
GROUP BY u.id,
u.name,
u.email
HAVING count(o.id) > 0
ORDER BY total_spent desc
LIMIT 10;;