WITH T as (
  SELECT strftime('%Y-%m-01', SALES_DATE) YEAR_MONTH, SUM(SALES_AMT) SALES_AMT 
  FROM SALES
  WHERE SALES_DATE >= '2022-01-01'
    and SALES_DATE < '2024-01-01'
    and UPDATED_NO is null
  GROUP BY strftime('%Y-%m-01', SALES_DATE)
)

SELECT
  S.YEAR_MONTH
 ,S.SALES_AMT as MONTH_AMT
 ,(SELECT SUM(T.SALES_AMT) FROM T WHERE T.YEAR_MONTH >= '2023-01-01' and T.YEAR_MONTH <= S.YEAR_MONTH) as CUML_AMT
 ,(SELECT SUM(T.SALES_AMT) FROM T WHERE T.YEAR_MONTH >= DATE(S.YEAR_MONTH, '-11 months') and T.YEAR_MONTH <= S.YEAR_MONTH) as YEAR_MOVE_AMT
FROM T S
WHERE YEAR_MONTH >= '2023-01-01'
  and YEAR_MONTH < '2024-01-01'
ORDER BY 1