WITH SALES_YM AS(
    SELECT
        STRFTIME('%Y-%m', SALES_DATE) AS YM
        ,SUM(SALES_AMT) AS MONTH_AMT
    FROM
        SALES
    WHERE
        YM >= "2022-01"
        AND UPDATED_NO IS NULL
    GROUP BY
        YM
    ORDER BY
        YM
)
,Z_CHART AS(
    SELECT
        YM AS YEAR_MONTH
        ,MONTH_AMT
        ,SUM(MONTH_AMT) OVER(
            ORDER BY
                YM ROWS BETWEEN 11 PRECEDING AND CURRENT ROW
        ) AS YEAR_MOVE_AMT
    FROM
        SALES_YM
)
SELECT
    YEAR_MONTH
    ,MONTH_AMT
    ,SUM(MONTH_AMT) OVER(ORDER BY YEAR_MONTH) AS CUML_AMT
    ,YEAR_MOVE_AMT
FROM
    Z_CHART
WHERE
    YEAR_MONTH BETWEEN '2023-01' AND '2023-12'
ORDER BY
    YEAR_MONTH ASC;