with temp as (
select 
    substr(SALES_DATE,1,7) as yyyymm
    ,sales_amt as amt
from 
    sales
)
select
    ym as YEAR_MONTH
    ,ym_amt as MONTH_AMT
    ,cuml_amt
    ,yma as YEAR_MOVE_AMT
from
(
    select
        ym
        ,ym_amt
        ,sum(ym_amt) over(order by ym) as CUML_AMT
        ,sum(ym_amt) over(order by ym rows between 11 preceding and current row) as yma
        
    from
        (
         select
            yyyymm as ym
            ,sum(amt) as ym_amt
        from
            temp
        group by 
            yyyymm
        )
 )   
where   
    ym between '2023-01' and '2023-12'
order by 
    1