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
        STRFTIME('%Y-%m',SALES_DATE)
    ),
SUB2 AS(
    SELECT
        YEAR_MONTH,
        SUM(MONTH_AMT) OVER(
            ORDER BY YEAR_MONTH
            ROWS BETWEEN 11 PRECEDING AND CURRENT ROW
            ) AS YEAR_MOVE_AMT
    FROM
        SUB
    )
SELECT
    SUB.YEAR_MONTH,
    MONTH_AMT,
    SUM(MONTH_AMT) OVER(
        ORDER BY SUB.YEAR_MONTH
        ) AS CUML_AMT,
    YEAR_MOVE_AMT
FROM
    SUB
    INNER JOIN SUB2
        ON SUB.YEAR_MONTH=SUB2.YEAR_MONTH
WHERE
    SUB.YEAR_MONTH BETWEEN '2023-01' AND '2023-12'
ORDER BY
    SUB.YEAR_MONTH ASC
    ;