sql 季度

CREATE TABLE sales (
    id INT PRIMARY KEY,
    sale_date DATE,
    amount DECIMAL(10, 2)
);

SELECT 
    DATE_FORMAT(sale_date, '%Y-Q%u') AS quarter,
    SUM(amount) AS total_sales
FROM 
    sales
GROUP BY 
    quarter;

WITH quarterly_sales AS (
    SELECT 
        DATE_FORMAT(sale_date, '%Y-Q%u') AS quarter,
        amount
    FROM 
        sales
)
SELECT 
    quarter,
    SUM(amount) OVER (ORDER BY quarter ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_sales
FROM 
    quarterly_sales
ORDER BY 
    quarter;

SELECT 
    DATE_FORMAT(sale_date, '%Y-Q%u') AS quarter
FROM 
    sales;

WITH quarterly_totals AS (
    SELECT 
        DATE_FORMAT(sale_date, '%Y-Q%u') AS quarter,
        SUM(amount) AS total_sales
    FROM 
        sales
    GROUP BY 
        quarter
)
SELECT 
    q1.quarter AS previous_quarter,
    q2.quarter AS current_quarter,
    ((q2.total_sales - q1.total_sales) / q1.total_sales) * 100 AS growth_rate
FROM 
    quarterly_totals q1
JOIN 
    quarterly_totals q2 ON q2.quarter = CONCAT(SUBSTRING(q1.quarter, 1, 4), '-', CAST(SUBSTRING(q1.quarter, 6, 1) AS INT) + 1);