with SALES_MON as(
	select
		 substr(SALES_DATE, 1, 7) as YEAR_MONTH
		,sum(SALES_AMT) as MONTH_AMT
	from SALES
	where UPDATED_NO is null
	group by YEAR_MONTH
)
,ans as (
	select
		 YEAR_MONTH
		,MONTH_AMT
		,sum(case
				when date(YEAR_MONTH || '-01') between date('2023-01-01') and date(YEAR_MONTH || '-01') then MONTH_AMT
			 	else 0
			 end ) over (order by YEAR_MONTH) as CUML_AMT
		--,sum(case
		--		when date(YEAR_MONTH || '-01') between date(YEAR_MONTH || '-01' , '-11 months') and date(YEAR_MONTH || '-01') then MONTH_AMT
		--	 	else 0
		--	 end ) over (order by YEAR_MONTH) as YEAR_MOVE_AMT
		,sum(MONTH_AMT) over (order by YEAR_MONTH ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) as YEAR_MOVE_AMT
	from
		SALES_MON
)
select YEAR_MONTH, MONTH_AMT, CUML_AMT, YEAR_MOVE_AMT
from ans
where YEAR_MONTH between '2023-01' and '2023-12'
order by
	YEAR_MONTH