منسق 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;