WITH monthly_sales as (select strftime('%Y-%m', sales_date) as YEAR_MONTH, sum(SALES_AMT) as MONTH_AMT from sales where sales_date >= '2022-01-01' and sales_date <= '2023-12-01' and UPDATED_NO is NULL group by YEAR_MONTH)
select 
  YEAR_MONTH, 
  MONTH_AMT, 
  sum(MONTH_AMT) OVER (order by YEAR_MONTH) as CUML_AMT, 
  sum(MONTH_AMT) over (ORDER BY YEAR_MONTH rows BETWEEN 11 PRECEDING AND CURRENT ROW) as YEAR_MOVE_AMT
 from monthly_sales 
 where YEAR_MONTH >= '2023-01' AND YEAR_MONTH <= '2023-12' order by YEAR_MONTH;