WITH MonthlySales AS (
    SELECT
        STRFTIME('%Y-%m', SALES_DATE) AS YEAR_MONTH,
        SUM(CASE WHEN SALES_TYPE = 2 THEN -SALES_AMT ELSE SALES_AMT END) AS MONTH_AMT
    FROM
        SALES
    WHERE
        UPDATED_NO IS NULL
        AND STRFTIME('%Y', SALES_DATE) = '2023'
    GROUP BY
        YEAR_MONTH
),
CumulativeSales AS (
    SELECT
        MS1.YEAR_MONTH,
        MS1.MONTH_AMT,
        (SELECT SUM(MS2.MONTH_AMT) FROM MonthlySales MS2 WHERE MS2.YEAR_MONTH <= MS1.YEAR_MONTH) AS CUML_AMT
    FROM
        MonthlySales MS1
),
MovingYearTotal AS (
    SELECT
        CS.YEAR_MONTH,
        CS.MONTH_AMT,
        CS.CUML_AMT,
        (SELECT SUM(MS.MONTH_AMT) FROM MonthlySales MS 
         WHERE MS.YEAR_MONTH BETWEEN 
         STRFTIME('%Y-%m', DATE(CS.YEAR_MONTH || '-01', '-11 month')) AND CS.YEAR_MONTH) AS YEAR_MOVE_AMT
    FROM
        CumulativeSales CS
)
SELECT
    YEAR_MONTH,
    MONTH_AMT,
    CUML_AMT,
    YEAR_MOVE_AMT
FROM
    MovingYearTotal
ORDER BY
    YEAR_MONTH;