在U-SQL中使用多个透视来输出多个列？

@inputData =
    SELECT *
    FROM inputTable;

@outputData =
    SELECT *
    FROM
    (
        SELECT Column1, Column2, Column3
        FROM @inputData
    )
    PIVOT
    (
        SUM(Column2)
        FOR Column1
        IN (Value1, Value2, Value3)
    ) AS P1
    PIVOT
    (
        AVG(Column3)
        FOR Column1
        IN (Value4, Value5, Value6)
    ) AS P2;

OUTPUT @outputData
TO outputTable
USING Outputters.Csv();