SELECT BaoBeiName, COUNT(*) AS SalesCount
FROM Sale
GROUP BY BaoBeiName
ORDER BY COUNT(*) DESC; -- 或 ORDER BY SalesCount DESC (別名)
先按商品分組計數,再按銷量降序輸出熱銷榜。
SELECT BaoBeiName, SUM(Price) AS TotalAmount
FROM Sale
GROUP BY BaoBeiName
ORDER BY SUM(Price) DESC; -- 或 ORDER BY TotalAmount DESC
先按商品分組求和,再按總金額降序輸出金額榜。
SELECT 列表只能包含:GROUP BY 列、聚合函數、常量/表達式。ORDER BY 可引用 SELECT 別名、聚合表達式、或未出現在 SELECT 中的列(部分數據庫限制)。FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY,故 ORDER BY 可見 SELECT 別名。