with A as (
select
    substring(SALES_DATE,1,7) as YEAR_MONTH,
    max(substring(SALES_DATE,1,4)) as YEAR,
    sum(sales_amt) as month_amt
from
    SALES
where
    UPDATED_NO is null
    and
    substring(SALES_DATE,1,4) in ('2022','2023')
group by
    substring(SALES_DATE,1,7)
), B as (
select
    YEAR_MONTH,
    YEAR,
    MONTH_AMT,
    sum(MONTH_AMT) over(partition by YEAR order by YEAR_MONTH) as CUML_AMT,
    cast(avg(MONTH_AMT) over(order by YEAR_MONTH rows between 12 preceding and current row) as int) as YEAR_MOVE_AMT
from
    A
)
select
    YEAR_MONTH,
    MONTH_AMT,
    CUML_AMT,
    YEAR_MOVE_AMT
from
    B
where
    YEAR = '2023'
order by
    YEAR_MONTH

;