WITH tmp3 as (
SELECT SUM(SALES_AMT)  MONTH_AMT3,
SUBSTRING(SALES_DATE,1,7)  YEAR_MONTH3
from SALES
where UPDATED_NO is null 
and SALES_TYPE != 2
group by YEAR_MONTH3
),
tmp2 as (
SELECT SUM(SALES_AMT)  MONTH_AMT2,
SUBSTRING(SALES_DATE,1,7)  YEAR_MONTH2
from SALES
where UPDATED_NO is null 
and SALES_TYPE = 2 
group by YEAR_MONTH2
),
tmp as 
(
SELECT
case when  MONTH_AMT2 is not null 
then MONTH_AMT3+MONTH_AMT2
else MONTH_AMT3 END
MONTH_AMT
, YEAR_MONTH3 YEAR_MONTH
from tmp3 left join tmp2 on tmp2.YEAR_MONTH2 = tmp3.YEAR_MONTH3
)
, result as (
select 
MONTH_AMT,YEAR_MONTH,
sum(MONTH_AMT) filter (WHERE YEAR_MONTH>='2023-01') over (order by YEAR_MONTH) CUML_AMT,
sum(MONTH_AMT) over (order by YEAR_MONTH rows 11 PRECEDING          ) YEAR_MOVE_AMT
from tmp)
select * from result
where YEAR_MONTH between '2023-01' and  '2023-12'
order by YEAR_MONTH