with t as(
select
    *,strftime('%Y-%m', date(sales_date))as YEAR_MONTH,sum(SALES_AMT)as MONTH_AMT
from
    SALES
where UPDATED_NO is null 
group by
    strftime('%Y-%m', date(sales_date))

)
,t2 as(
select
    
    YEAR_MONTH,MONTH_AMT
    ,sum(MONTH_AMT)over(order by year_month)as CUML_AMT
    
from
    t
where
    sales_date>='2023-01-01'
order by 1 asc
)
,t3 as(

select
    YEAR_MONTH
    
    ,sum(MONTH_AMT)over(order by year_month asc rows between 11 preceding and current row)as YEAR_MOVE_AMT
    
from
    t

order by 1 asc
)
,t4 as(
select
    YEAR_MONTH,YEAR_MOVE_AMT
from
    t3
where year_month>='2023-01'
)

select
    t2.YEAR_MONTH,MONTH_AMT,CUML_AMT,YEAR_MOVE_AMT
from
    t2 left join t4 on t2.year_month=t4.year_month
order by 1 asc