with cte as (
select
    substr(SALES_DATE,1,7) as YEAR_MONTH
    ,sum(SALES_AMT) as MONTH_AMT
from
    SALES
where
    UPDATED_NO is null
group by
    YEAR_MONTH
)
,cte2 as (
select
    YEAR_MONTH
    , MONTH_AMT
    ,sum(MONTH_AMT) over (order by YEAR_MONTH ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as CUML_AMT
from
    cte
where
    YEAR_MONTH between "2023-01" and "2023-12"
)
,cte3 as (
select
    YEAR_MONTH
    ,sum(MONTH_AMT) over (order by YEAR_MONTH ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) as YEAR_MOVE_AMT
from
    cte
)
select
    cte2.YEAR_MONTH
    ,MONTH_AMT
    ,CUML_AMT
    ,YEAR_MOVE_AMT
from
    cte2
    inner join
    cte3
    on cte2.YEAR_MONTH =cte3.YEAR_MONTH
order by
    cte2.YEAR_MONTH