WITH SUB AS(
    SELECT
        STRFTIME("%Y-%m", DATE(SALES_DATE)) AS YM
        ,SUM(SALES_AMT) AS MONTH_AMT
    FROM
        SALES
    WHERE
        UPDATED_NO IS NULL
        -- AND DATE(SALES_DATE) BETWEEN '2023-01-01' AND '2023-12-31'
    GROUP BY
        YM
), SUB2 AS(
    SELECT
        YM
        ,MONTH_AMT
        ,SUM(MONTH_AMT) OVER(ORDER BY YM ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) AS YEAR_MOVE_AMT
    FROM
        SUB
)
SELECT
    YM AS YEAR_MONTH
    ,MONTH_AMT
    ,SUM(MONTH_AMT) OVER(ORDER BY YM) AS CUML_AMT
    ,YEAR_MOVE_AMT
FROM
    SUB2
WHERE
    YM BETWEEN '2023-01' AND '2023-12'