使用SQL PIVOT按日期和百分比汇总数据

SELECT *
FROM (
  SELECT date, category, value
  FROM your_table
) AS source
PIVOT (
  SUM(value)
  FOR date IN ([2022-01-01], [2022-01-02], [2022-01-03])
) AS pivot_table;

SELECT
  [2022-01-01],
  [2022-01-02],
  [2022-01-03],
  ([2022-01-01] / ([2022-01-01] + [2022-01-02] + [2022-01-03])) * 100 AS percentage_2022_01_01,
  ([2022-01-02] / ([2022-01-01] + [2022-01-02] + [2022-01-03])) * 100 AS percentage_2022_01_02,
  ([2022-01-03] / ([2022-01-01] + [2022-01-02] + [2022-01-03])) * 100 AS percentage_2022_01_03
FROM (
  SELECT date, category, value
  FROM your_table
) AS source
PIVOT (
  SUM(value)
  FOR date IN ([2022-01-01], [2022-01-02], [2022-01-03])
) AS pivot_table;