with tmp1 as (
    select
        substr(sales_date,1,7) as YEAR_MONTH,
        sum(sales_amt) as MONTH_AMT
    from sales
    where updated_no is null
    group by year_month
),
tmp2 as (
    select
        *,
        sum(month_amt) over(order by year_month rows between 11 preceding and current row) as YEAR_MOVE_AMT
    from tmp1
),
tmp3 as (
    select
        *,
        sum(month_amt) over(order by year_month rows between unbounded preceding and current row) as CUML_AMT
    from tmp1
    where year_month between '2023-01' and '2023-12'
)
select 
    *
from tmp3
inner join tmp2
on tmp2.year_month=tmp3.year_month;