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
    YEAR_MONTH>='2023-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
)
select
    t2.YEAR_MONTH,MONTH_AMT,CUML_AMT,YEAR_MOVE_AMT
from
    t2 join t3 on t2.year_month=t3.year_month
order by 1 asc