تعلم قواعد بيانات SQL Database: post #707 — TG.ME

SELECT
    CustomerID,
    COUNT(*) AS OrderCount
FROM Orders
GROUP BY CustomerID
ORDER BY OrderCount DESC;