WITH T1 AS(
    SELECT
        SUBSTR(SALES_DATE, 1, 7) AS YEAR_MONTH,
        SUM(SALES_AMT) AS MONTH_AMT
    FROM
        SALES
    WHERE
        UPDATED_NO IS NULL
    GROUP BY
        YEAR_MONTH
), T2 AS(
    SELECT
        YEAR_MONTH,
        MONTH_AMT,
        SUM(MONTH_AMT) OVER(
            PARTITION BY SUBSTR(YEAR_MONTH, 1, 4)
            ORDER BY YEAR_MONTH ASC
        ) AS CUML_AMT,
        SUM(MONTH_AMT) OVER(
            ORDER BY YEAR_MONTH ASC
            ROWS BETWEEN 11 PRECEDING AND 0 PRECEDING
        ) AS YEAR_MOVE_AMT
    FROM
        T1
)
SELECT
    *
    FROM T2
    WHERE
        SUBSTR(YEAR_MONTH, 1, 4) = '2023'