SQL Input
select u.id, u.name, o.total from users u inner join orders o on o.user_id = u.id where u.active = 1 and o.total > 100 group by u.id, u.name order by o.total desc limit 10;
Formatted
Copy