WITH FilteredData AS (
  SELECT
    STRFTIME('%Y-%m', SALES_DATE) AS YEAR_MONTH,
    SUM(SALES_AMT) AS MONTH_AMT,
    SALES_DATE
  FROM
    SALES
  WHERE
    SALES_DATE >= '2022-01-01'
    AND UPDATED_NO IS NULL
  GROUP BY
    YEAR_MONTH
)
SELECT
  YEAR_MONTH,
  MONTH_AMT,
  SUM(MONTH_AMT) OVER (
    ORDER BY YEAR_MONTH
    RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
  ) AS CUML_AMT,
  SUM(MONTH_AMT) OVER (
    ORDER BY YEAR_MONTH
    RANGE BETWEEN 11 PRECEDING AND CURRENT ROW
  ) AS YEAR_MOVE_AMT
FROM
  FilteredData
WHERE
  YEAR_MONTH BETWEEN '2023-01' AND '2023-12' 
ORDER BY
  YEAR_MONTH;