with YEAR_SUM as (
with MONTH_SUM as (
select
   strftime('%Y-%m',SALES_DATE) as YEAR_MONTH
 , strftime('%Y-%m',date(SALES_DATE, '-11 month')) as YEAR_MONTH_11
 , sum(SALES_AMT) as MONTH_AMT
from
  SALES
where
     SALES_DATE between '2022-02-01' and '2023-12-31'
 and UPDATED_NO is null
group by
  strftime('%Y-%m',SALES_DATE)
)

select
   M.YEAR_MONTH
 , M.MONTH_AMT
 , sum(Y.MONTH_AMT) as YEAR_MOVE_AMT
from
   MONTH_SUM M
   join MONTH_SUM Y
     on Y.YEAR_MONTH between M.YEAR_MONTH_11 and M.YEAR_MONTH
where
  M.YEAR_MONTH >= '2023-01'
group by
   M.YEAR_MONTH
 , M.MONTH_AMT
)

select
   Y.YEAR_MONTH
 , Y.MONTH_AMT
 , sum(C.MONTH_AMT) as CUML_AMT
 , Y.YEAR_MOVE_AMT
from
   YEAR_SUM Y
   join YEAR_SUM C
     on C.YEAR_MONTH between '2023-01' and Y.YEAR_MONTH
group by
   Y.YEAR_MONTH
 , Y.MONTH_AMT
order by
   Y.YEAR_MONTH asc;