mysql 分组排列

CREATE TABLE sales (
    id INT AUTO_INCREMENT PRIMARY KEY,
    product_id INT,
    category VARCHAR(50),
    amount DECIMAL(10, 2),
    sale_date DATE
);

SELECT category, SUM(amount) AS total_sales
FROM sales
GROUP BY category;

SELECT category, SUM(amount) AS total_sales
FROM sales
WHERE category IS NOT NULL
GROUP BY category;

SELECT category, SUM(amount) AS total_sales
FROM sales
GROUP BY category
ORDER BY total_sales DESC;

SELECT category, SUM(amount) AS total_sales
FROM sales
WHERE sale_date BETWEEN '2023-01-01' AND '2023-12-31'
GROUP BY category;

SELECT category, SUM(amount) AS total_sales
FROM sales
GROUP BY category
HAVING total_sales > 1000;