WITH
    SALES_YM AS (
        SELECT
            STRFTIME ('%Y-%m', SALES_DATE) AS YEAR_MONTH,
            SUM(SALES_AMT) AS MONTH_AMT
        FROM
            SALES
        WHERE
            YEAR_MONTH >= '2022-01'
            AND UPDATED_NO IS NULL
        GROUP BY
            YEAR_MONTH
    ),
    Z_CHART AS (
        SELECT
            YEAR_MONTH AS YEAR_MONTH,
            MONTH_AMT AS MONTH_AMT,
            SUM(MONTH_AMT) OVER (
                ORDER BY
                    YEAR_MONTH 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;