T-SQL不带笛卡尔结果的多个pivot语句

-- 创建一个示例表
CREATE TABLE Sales (
    Product varchar(50),
    Region varchar(50),
    Year int,
    Amount decimal(10, 2)
);

-- 插入示例数据
INSERT INTO Sales (Product, Region, Year, Amount)
VALUES ('Product A', 'Region 1', 2019, 100),
       ('Product A', 'Region 2', 2019, 200),
       ('Product B', 'Region 1', 2019, 150),
       ('Product B', 'Region 2', 2019, 250),
       ('Product A', 'Region 1', 2020, 120),
       ('Product A', 'Region 2', 2020, 220),
       ('Product B', 'Region 1', 2020, 160),
       ('Product B', 'Region 2', 2020, 260);

-- 使用多个PIVOT语句进行数据转换
SELECT *
FROM (
    SELECT Product, Region, Year, Amount
    FROM Sales
) AS SourceTable
PIVOT (
    SUM(Amount)
    FOR Year IN ([2019], [2020])
) AS PivotTable1
PIVOT (
    SUM([2019]), SUM([2020])
    FOR Region IN ([Region 1], [Region 2])
) AS PivotTable2;