with tmp as(
select substr(SALES_DATE, 0, 8) YEAR_MONTH
, sum(SALES_AMT) MONTH_AMT
, sum(SALES_AMT) filter (where SALES_DATE >= '2023-01-01') MONTH_AMT2
from sales
where UPDATED_NO is null
-- and SALES_DATE between '2023-01-01' and '2023-12-31'
group by substr(SALES_DATE, 0, 8)
)
select * from (
select YEAR_MONTH,MONTH_AMT
,sum(MONTH_AMT2) over(order by YEAR_MONTH) CUML_AMT
,sum(MONTH_AMT) over(order by YEAR_MONTH ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) YEAR_MOVE_AMT
-- ROWS BETWEEN 2 PRECEDING AND CURRENT ROW
from tmp
) tmp2
where Year_Month between '2023-01'and '2023-12'