with t1 as 
(
  select 
    strftime('%Y-%m', sales_date) as YEAR_MONTH
    ,sum(sales_amt) as MONTH_AMT
  from sales 
  where updated_no is NULL 
    and sales_date >= '2023-01-01'
    and sales_date < '2024-01-01'
  group by 1 
--   order by 1
)
, t2 as 
(
  select 
    YEAR_MONTH
    ,MONTH_AMT
    ,sum(MONTH_AMT) over (order by YEAR_MONTH) as CUML_AMT
  from t1 
)
, t3 as 
(
  select 
    strftime('%Y-%m', sales_date) as YEAR_MONTH
    ,sum(sales_amt) as MONTH_AMT
  from sales 
  where updated_no is NULL 
    and sales_date >= '2022-01-01'
    -- and sales_date < '2024-01-01'
  group by 1 
)
, t4 as 
(
select 
  YEAR_MONTH
  ,MONTH_AMT
  ,SUM(MONTH_AMT) OVER (ORDER BY YEAR_MONTH ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) as YEAR_MOVE_AMT
from t3
)
select 
  t2.YEAR_MONTH
  ,t2.MONTH_AMT
  ,t2.CUML_AMT
  ,t4.YEAR_MOVE_AMT
from t2
inner join t4
  on t2.YEAR_MONTH = t4.YEAR_MONTH
order by t2.YEAR_MONTH
;