with getuzi as(
    select
        substr(sales_date,1,7) as ym
        ,sum(sales_amt) as ma
    from sales
    where updated_no is null
    group by substr(sales_date,1,7)
)
,ruikei as(
    select
        ym
        ,sum(ma)over(order by ym) as ca
    from getuzi
    where ym between '2023-01' and '2023-12'
)
,idou as(
    select
        ym
        ,sum(ma)over(order by ym rows 11 preceding ) as yma
    from getuzi
)
select
    ruikei.ym as YEAR_MONTH
    ,ma as MONTH_AMT
    ,ca as CUML_AMT
    ,yma as YEAR_MOVE_AMT
from ruikei
inner join getuzi on getuzi.ym = ruikei.ym
inner join idou  on idou.ym=ruikei.ym
order by ruikei.ym