with st as( select *, strftime('%Y-%m', sales_date) as YEAR_MONTH from sales
where updated_no is null
)
, stg as (
select YEAR_MONTH, sum(sales_amt) as amt from st group by YEAR_MONTH order by YEAR_MONTH
)
, stg2 as (
select YEAR_MONTH, amt, sum(amt) over (rows between 11 preceding and current row) as yearamt
from stg
)
select 
YEAR_MONTH
, amt as MONTH_AMT
, sum(amt) over (order by YEAR_MONTH) as CUML_AMT
, yearamt as YEAR_MOVE_AMT
from stg2
where year_month between '2023-01' and '2023-12'
-- select 
-- from stg
-- where year_month between '2023-01' and '2023-12'
-- and sales_date between '2023-01-01' and '2023-12-31'