مصغر SQL

select users.id, users.email, count(orders.id) as order_count from users left join orders on orders.user_id = users.id where users.status = 'active' group by users.id, users.email order by order_count desc limit 10;