WITH
    sub AS 
        (
        SELECT
            STRFTIME('%Y-%m', SALES_DATE)  AS YEAR_MONTH
            ,SUM(SALES_AMT) AS MONTH_AMT
        FROM
            SALES
        WHERE
            UPDATED_NO IS NULL
        GROUP BY
            YEAR_MONTH
        ORDER BY
            YEAR_MONTH ASC
        )
    ,sub2 as
        (
        SELECT
            YEAR_MONTH
            ,MONTH_AMT
            ,sum(MONTH_AMT)over(order by YEAR_MONTH) as CUML_AMT
        FROM
            sub
        WHERE
            YEAR_MONTH between '2023-01' and '2023-12'
        )
    ,sub3 as
        (
        SELECT
            YEAR_MONTH
            ,MONTH_AMT
            ,sum(MONTH_AMT)over(order by YEAR_MONTH rows 11 preceding) as YEAR_MOVE_AMT
        FROM
            sub
        )
--select * from sub3
SELECT
    sub2.YEAR_MONTH
    ,sub2.MONTH_AMT
    ,sub2.CUML_AMT
    ,sub3.YEAR_MOVE_AMT
FROM
    sub2
    inner join sub3
    on sub2.YEAR_MONTH = sub3.YEAR_MONTH
ORDER BY
    sub2.YEAR_MONTH asc