WITH SALES_YM AS
(SELECT
strftime('%Y-%m',SALES_DATE ) AS YEAR_MONTH,
SUM(SALES_AMT) AS MONTH_AMT
FROM
SALES
WHERE
UPDATED_NO IS NULL
AND
SALES_DATE >= '2022-01-01'
GROUP BY
YEAR_MONTH)


SELECT
t1.YEAR_MONTH,
t1.MONTH_AMT,
SUM(MONTH_AMT) OVER (ORDER BY t1.YEAR_MONTH ASC) AS CUML_AMT,
YEAR_MOVE_AMT
FROM
SALES_YM t1
LEFT JOIN
(SELECT
YEAR_MONTH,
/*MONTH_AMT,*/
SUM(MONTH_AMT) OVER (ORDER BY YEAR_MONTH ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) AS YEAR_MOVE_AMT
FROM
SALES_YM
GROUP BY YEAR_MONTH) t2
ON
t1.YEAR_MONTH = t2.YEAR_MONTH
WHERE t1.YEAR_MONTH >= '2023-01'
GROUP BY t1.YEAR_MONTH
ORDER BY
t1.YEAR_MONTH