select substr(SALES_DATE,1,7) as YEAR_MONTH,
sum(SALES_AMT) as MONTH_AMT,
sum(sum(SALES_AMT)) over(order by substr(SALES_DATE,1,7)) as CUML_AMT,
(select sum(b.SALES_AMT)
   from SALES b
  where substr(b.SALES_DATE,1,7)
between substr(date(substr(a.SALES_DATE,1,7) || '-01','-11 months'),1,7)
    and substr(a.SALES_DATE,1,7)
      and b.UPDATED_NO is null) as YEAR_MOVE_AMT
  from SALES a
 where UPDATED_NO is null
   and SALES_DATE between '2023-01-01' and '2023-12-31'
group by substr(SALES_DATE,1,7)
order by substr(SALES_DATE,1,7)