WITH MonthlySales AS (
    SELECT
        STRFTIME('%Y-%m', SALES_DATE) AS YEAR_MONTH,
        SUM(SALES_AMT) AS MONTH_AMT
    FROM
        SALES
    WHERE
        SALES_DATE BETWEEN '2023-01-01' AND '2023-12-31'
        AND UPDATED_NO IS NULL
    GROUP BY
        YEAR_MONTH
),
CumulativeSales AS (
    SELECT
        a.YEAR_MONTH,
        a.MONTH_AMT,
        (SELECT SUM(b.MONTH_AMT) FROM MonthlySales b WHERE b.YEAR_MONTH <= a.YEAR_MONTH) AS CUML_AMT
    FROM
        MonthlySales a
),
MovingYearTotal AS (
    SELECT
        a.YEAR_MONTH,
        a.MONTH_AMT,
        a.CUML_AMT,
        (SELECT SUM(b.MONTH_AMT) FROM MonthlySales b WHERE b.YEAR_MONTH BETWEEN 
            (SELECT MIN(YEAR_MONTH) FROM MonthlySales WHERE YEAR_MONTH < a.YEAR_MONTH ORDER BY YEAR_MONTH DESC LIMIT 11) 
            AND a.YEAR_MONTH) AS YEAR_MOVE_AMT
    FROM
        CumulativeSales a
)

SELECT
    YEAR_MONTH,
    MONTH_AMT,
    CUML_AMT,
    IFNULL(YEAR_MOVE_AMT, 0) AS YEAR_MOVE_AMT
FROM
    MovingYearTotal
ORDER BY
    YEAR_MONTH;