在SQL中:如何获取按月分组的两列的百分比

SELECT MONTH(date_column) AS month, column1, column2
FROM table_name
GROUP BY MONTH(date_column), column1, column2

SELECT month, SUM(column1) AS sum_column1, SUM(column2) AS sum_column2
FROM (
    SELECT MONTH(date_column) AS month, column1, column2
    FROM table_name
    GROUP BY MONTH(date_column), column1, column2
) AS subquery
GROUP BY month

SELECT month, (sum_column1 / (sum_column1 + sum_column2)) * 100 AS percentage_column1,
    (sum_column2 / (sum_column1 + sum_column2)) * 100 AS percentage_column2
FROM (
    SELECT month, SUM(column1) AS sum_column1, SUM(column2) AS sum_column2
    FROM (
        SELECT MONTH(date_column) AS month, column1, column2
        FROM table_name
        GROUP BY MONTH(date_column), column1, column2
    ) AS subquery
    GROUP BY month
) AS subquery2