sql битрикс ценные пользователи
SELECT
`USER_ID`,
COUNT(*) AS quantity,
ROUND(SUM(PRICE)) AS summa
FROM `b_sale_order`
WHERE
`LID` = 's1' AND
`CANCELED` = 'N' AND
`DATE_INSERT` > '2021-01-01'
GROUP BY USER_ID
ORDER BY summa DESC
LIMIT 50