with SALE AS (
select  SUBSTR(SALES_DATE, 1, 7) as YM,
sum(SALES_AMT) as MA
from SALES
where UPDATED_NO is null
and SALES_DATE >= '2022-01'
group by YM
),Z AS (
select YM AS YEAR_MONTH,
MA as MONTH_AMT,
sum(MA) over (order by YM rows between 11 PRECEDING AND CURRENT ROW) AS YEAR_MOVE_AMT
from SALE
)
select YEAR_MONTH,
MONTH_AMT,
sum(MONTH_AMT) over (order by YEAR_MONTH) as CUML_AMT,
YEAR_MOVE_AMT
from Z
where YEAR_MONTH between '2023-01'
and '2023-12'
order by YEAR_MONTH asc