mysql按年月统计数量

SELECT 
    YEAR(order_date) AS year,
    MONTH(order_date) AS month,
    COUNT(*) AS order_count
FROM 
    orders
GROUP BY 
    YEAR(order_date), MONTH(order_date)
ORDER BY 
    year, month;

SELECT 
    YEAR(order_date) AS year,
    COUNT(*) AS order_count
FROM 
    orders
GROUP BY 
    YEAR(order_date)
ORDER BY 
    year;

SELECT 
    YEAR(order_date) AS year,
    MONTH(order_date) AS month,
    COUNT(*) AS order_count
FROM 
    orders
GROUP BY 
    YEAR(order_date), MONTH(order_date)
ORDER BY 
    year, month;

CREATE INDEX idx_order_date ON orders(order_date);

SELECT 
    YEAR(order_date) AS year,
    MONTH(order_date) AS month,
    COUNT(*) AS order_count
FROM 
    orders
WHERE 
    order_date BETWEEN '2020-01-01' AND '2023-12-31'
GROUP BY 
    YEAR(order_date), MONTH(order_date)
ORDER BY 
    year, month
LIMIT 10 OFFSET 0;