with monthly_sales AS(
    SELECT  SUM(SALES_AMT) AS MONTH_AMT,
            STRFTIME('%Y-%m', SALES_DATE) AS YEAR_MONTH
    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    SALES
),
Total_Sales AS(
    SELECT  SUM(SALES_AMT) AS Total_MONTH_AMT,
            STRFTIME('%Y-%m', SALES_DATE) AS TOTAL_YEAR_MONTH
    FROM    SALES
    WHERE   UPDATED_NO IS NULL
    GROUP BY YEAR_MONTH
),
MovingYearTotal AS (
    SELECT  YEAR_MONTH,
            MONTH_AMT,
            CUML_AMT,
            (SELECT SUM(TOTAL_YEAR_MONTH) 
            FROM TotalSales
             WHERE TOTAL_YEAR_MONTH <= YEAR_MONTH) AS YEAR_MOVE_AMT
    GROUP BY CumulativeSales
)

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