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
    ,sum(ym_amt) over(order by ym) as CUML_AMT
    ,sum(ym_amt) over(order by ym rows BETWEEN 12 PRECEDING AND CURRENT ROW) as YEAR_MOVE_AMT
from
    (
     select
        yyyymm as ym
        ,sum(amt) as ym_amt
    from
        temp
    group by 
        yyyymm
    )
order by 
    1