with zmaster as (
    select substr(sales_date, 1, 7) ym, sum(sales_amt) ma
    from sales
    where updated_no is null
    group by substr(sales_date, 1, 7)
    order by ym
), z1 as (
    select ym, ma, sum(ma) over (
        order by ym
        rows between 11 preceding and current row
    ) yma
    from zmaster
)
select ym YEAR_MONTH, ma MONTH_AMT, sum(ma) over (order by ym rows between unbounded preceding and current row) CUML_AMT, yma YEAR_MOVE_AMT
from z1
where ym between '2023-01' and '2023-12'