with 
target as (
    select
        substr(SALES_DATE, 1, 7)      as YEAR_MONTH   
      , sum(SALES_AMT)                as SALES_AMT
    from
        SALES
    where
        UPDATED_NO is null
    group by
        YEAR_MONTH
    order by
        YEAR_MONTH asc
),
summary as (
    select
        YEAR_MONTH
      , SALES_AMT as MONTH_AMT -- 月次売上   
      , sum(case
                when YEAR_MONTH like '2023%' then SALES_AMT 
                else                              0
            end
        ) over(order by YEAR_MONTH asc)         as CUML_AMT -- 売上累計
      , sum(SALES_AMT) over (order by YEAR_MONTH asc ROWS 11 PRECEDING) as YEAR_MOVE_AMT -- 累積売上
    from
        target
)
select
    YEAR_MONTH
  , MONTH_AMT
  , CUML_AMT
  , YEAR_MOVE_AMT
from
    summary
where
    YEAR_MONTH like '2023%'
order by
    YEAR_MONTH;