MySQL CASE...WHERE...THEN 语句

MySQL CASE...WHERE...THEN 语句的用途和案例

SELECT
    CASE
        WHEN price < 50 THEN '低价产品'
        WHEN price >= 50 AND price < 100 THEN '中价产品'
        WHEN price >= 100 THEN '高价产品'
    END AS category,
    SUM(stock) AS total_stock
FROM
    products
GROUP BY
    category;