WITH RECURSIVE cc(calendar_date) AS (
    SELECT DATE('2023-01-01') AS calendar_date
    UNION ALL
    SELECT
        DATE(calendar_date, '+1 month') AS calendar_date
    FROM cc
    WHERE    calendar_date < DATE('2023-12-01')
),
cc2(YEAR_MONTH, YEAR_MOVE_AMT) AS (
    SELECT
        strftime('%Y-%m', calendar_date),
        (SELECT SUM(SALES_AMT) FROM SALES WHERE DATE(strftime('%Y-%m-01', calendar_date), '-11 months') <= SALES_DATE AND SALES_DATE < DATE(strftime('%Y-%m-01', calendar_date), '+1 month') AND UPDATED_NO IS NULL)
    FROM cc
),
S(YEAR_MONTH, MONTH_AMT, CUML_AMT) AS (
    SELECT strftime('%Y-%m', SALES_DATE) AS YEAR_MONTH,
        SUM(SALES_AMT),
        SUM(SUM(SALES_AMT)) OVER (ORDER BY SALES_DATE)
    FROM SALES S1 WHERE UPDATED_NO IS NULL AND SALES_DATE BETWEEN '2023-01-01' AND '2023-12-31' GROUP BY strftime('%Y-%m', SALES_DATE)
)
SELECT YEAR_MONTH, MONTH_AMT, CUML_AMT, YEAR_MOVE_AMT FROM cc2 LEFT JOIN S USING (YEAR_MONTH);