WITH pre AS(
SELECT
    strftime('%Y-%m', SALES_DATE) AS YEAR_MONTH,
    SUM(SALES_AMT) AS MONTH_AMT
FROM
    SALES
WHERE
    UPDATED_NO IS NULL
GROUP BY
    strftime('%Y-%m', SALES_DATE)
ORDER BY
    YEAR_MONTH
),
pre2 AS(
SELECT
    YEAR_MONTH,
    MIN(MONTH_AMT) AS MONTH_AMT,
    SUM(MONTH_AMT) FILTER(WHERE YEAR_MONTH BETWEEN '2022-12-01' AND '2023-12-31') OVER(ORDER BY YEAR_MONTH)  AS CUML_AMT,
    SUM(MONTH_AMT) OVER(ORDER BY YEAR_MONTH ROWS 11 PRECEDING) as YEAR_MOVE_AMT
FROM
    pre
GROUP BY
    YEAR_MONTH
)
SELECT
    YEAR_MONTH,
    MONTH_AMT,
    CUML_AMT,
    YEAR_MOVE_AMT
FROM
    pre2
WHERE
    YEAR_MONTH BETWEEN '2022-12-01' AND '2023-12-31'