with a as (
select
    ym,
    amt,
    sum(amt) over (
        order by
            ym
    ) as s
from
    (
        select
            strftime('%Y-%m', SALES_DATE) ym,
            sum(SALES_AMT) amt
        from
            SALES
        where
            UPDATED_NO is null
        group by
            strftime('%Y-%m', SALES_DATE)
    )
)
select 
a.ym YEAR_MONTH,
a.amt MONTH_AMT,
a.s-(select max(s) from a as sub where sub.ym<'2023-01') CUML_AMT,
a.s-(ifnull((select max(s) from a as sub where sub.ym<strftime('%Y-%m',date(a.ym||'-01','-11 months'))),0)) YEAR_MOVE_AMT
from 
a
where a.ym between '2023-01' and  '2023-12'
order by 1