SQL Formatter

select u.id, u.email, count(o.id) as order_count, sum(o.total) as revenue from users u left join orders o on o.user_id = u.id and o.status = 'completed' where u.created_at >= '2024-01-01' group by u.id, u.email having count(o.id) > 0 order by revenue desc limit 100

with ranked as (select user_id, total, row_number() over (partition by user_id order by total desc) as rn from orders) select user_id, total from ranked where rn = 1

insert into users (id, email, created_at) values (1, 'a@example.com', now()), (2, 'b@example.com', now()), (3, 'c@example.com', now()), (4, 'd@example.com', now())