SQL запрос с суммой по месяцам и нарастающим итогом

SELECT
    YEAR([ Pay_Date ]) AS [ YEAR ],
    MONTH([ Pay_Date ]) AS [ MONTH ],
    SUM(Abonent_Pay) AS Total
FROM
    Payment
WHERE
    ID = 555000555
GROUP BY
    YEAR([ Pay_Date ]),
    MONTH([ Pay_Date ])

SELECT
    YEAR([ T1.Pay_Date ]) AS [ YEAR ],
    MONTH([ T1.Pay_Date ]) AS [ MONTH ],
    SUM(T1.Abonent_Pay) AS Total,
    (
    SELECT
        SUM(T2.Abonent_Pay)
    FROM
        Payment AS T2
    WHERE
        T2.[ MONTH ] <= T1.[ MONTH ]
) AS Сumulative
FROM
    Payment AS T1
WHERE
    T1.ID = 555000555
GROUP BY
    YEAR([ T1.Pay_Date ]),
    MONTH([ T1.Pay_Date ])

SELECT T1.ID, YEAR(T1.Pay_Date) AS [YEAR], MONTH(T1.Pay_Date) AS [MONTH], 
       SUM(T1.Abonent_Pay) AS Total, 
       (SELECT SUM(Abonent_Pay) FROM Payment WHERE ID=T1.ID AND Format(Pay_Date,"yyyymm")<=Format(T1.Pay_Date,"yyyymm")) AS itog
FROM Payment AS T1
WHERE T1.ID=555000555
GROUP BY T1.ID, YEAR(T1.Pay_Date), MONTH(T1.Pay_Date), Format(T1.Pay_Date,"yyyymm")

SELECT T1.ID, CInt(LEFT(Format(Pay_Date,"yyyymm"),4)) AS [YEAR], CInt(RIGHT(Format(Pay_Date,"yyyymm"),2)) AS [MONTH], 
       SUM(T1.Abonent_Pay) AS Total, (SELECT SUM(Abonent_Pay) FROM Payment WHERE ID=T1.ID AND Format(Pay_Date,"yyyymm")<=Format(T1.Pay_Date,"yyyymm")) AS itog
FROM Payment AS T1
WHERE T1.ID=555000555
GROUP BY T1.ID, Format(T1.Pay_Date,"yyyymm")