with tmp as (
select
    strftime('%Y-%m', sales_date) sales_date
    ,sum(sales_amt) sum_amt
from
    sales
where
    updated_no is null
group by
    strftime('%Y-%m', sales_date)
), tmp2 as (
select
    sales_date YEAR_MONTH
    ,sum_amt MONTH_AMT
    ,sum(sum_amt) over(order by sales_date rows between 11 preceding and current row) YEAR_MOVE_AMT
from
    tmp
order by
    sales_date
)
select
    year_month
    ,month_amt
    ,sum(month_amt) over(order by year_month rows between unbounded preceding and current row) CUML_AMT
    ,year_move_amt
from
    tmp2
where
    year_month between '2023-01' and '2023-12'
order by
    year_month
;