with sales_ym as (
    select
        substr(SALES_DATE,1,7) as ym
        , sum(SALES_AMT) as mon_amt
    from sales
    where substr(SALES_DATE,1,7)>='2022-01'
    and   UPDATED_NO is null
    group by 1
),
z_chart as (
    select
        ym as YEAR_MONTH
        , mon_amt as MONTH_AMT
        , sum(mon_amt) over(order by ym rows between 11 PRECEDING and current row) as YEAR_MOVE_AMT
    from sales_ym
)
select 
    YEAR_MONTH
    , MONTH_AMT
    , sum(MONTH_AMT) over (order by YEAR_MONTH) as CUML_AMT
    , YEAR_MOVE_AMT
from z_chart
where YEAR_MONTH between '2023-01' and '2023-12'
order by 1;