SQL Formatter

select u.id, 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 = 1
and u.created_at > '2024-01-01'
group by u.id
order by order_count desc
limit 50;