WITH SUB_1 AS (
	SELECT
		strftime('%Y-%m', SALES_DATE) AS YEAR_MONTH
		, SUM(SALES_AMT) MONTH_AMT
	FROM
		SALES
	WHERE
		1=1
		AND UPDATED_NO IS NULL
	GROUP BY
		YEAR_MONTH
)
SELECT
	a.YEAR_MONTH
	, a.MONTH_AMT
	, SUM(a.MONTH_AMT) OVER (ORDER BY a.YEAR_MONTH ROWS UNBOUNDED PRECEDING) AS CUML_AMT
	, YEAR_MOVE_AMT
FROM
	SUB_1 a INNER JOIN (
	    SELECT
        	YEAR_MONTH
    	    , SUM(MONTH_AMT) OVER (ORDER BY YEAR_MONTH ROWS 11 PRECEDING) AS YEAR_MOVE_AMT
        FROM
            SUB_1
	) b
	ON a.YEAR_MONTH = b.YEAR_MONTH
WHERE
	1=1
	AND a.YEAR_MONTH BETWEEN '2023-01' AND '2023-12'
ORDER BY
	a.YEAR_MONTH
;