SELECT users.id, COUNT(orders.performer_id) as counter FROM users JOIN orders on users.id = orders.performer_id WHERE role = 'performer' AND orders.performer_id IS NOT NULL GROUP BY orders.performer_id ORDER BY counter DESC
SELECT users.id, COUNT(orders.performer_id) as counter FROM users JOIN orders on users.id = orders.performer_id WHERE role = 'performer' AND orders.performer_id IS NOT NULL GROUP BY orders.performer_id ORDER BY counter DESC
Как в билдере отсортировать пользователей по количеству заказов и вывести пользователей =((((( нужно использовать именно методы билдера with count и т.д.