Format a compact SELECT query
Readable SQL helps reviewers understand query intent faster.
Input
select u.id,u.email,count(o.id) from users u left join orders o on o.user_id=u.id where u.active=1 group by u.id,u.email order by count(o.id) desc
Output
SELECT u.id, u.email, count(o.id)
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.active = 1
GROUP BY u.id, u.email
ORDER BY count(o.id) DESC