WITH MONTH AS (
    SELECT SUBSTR(SALES_DATE, 1, 7) AS YEAR_MONTH
          ,SUM(SALES_AMT) AS MONTH_AMT
      FROM SALES
     WHERE UPDATED_NO IS NULL
     GROUP BY SUBSTR(SALES_DATE, 1, 7)
     ORDER BY YEAR_MONTH
)
,CUML AS (
    SELECT YEAR_MONTH
          ,SUM(MONTH_AMT) OVER(ORDER BY YEAR_MONTH) AS CUML_AMT
      FROM MONTH
     WHERE YEAR_MONTH BETWEEN '2023-01' AND '2023-12'
     ORDER BY YEAR_MONTH
)
,YEAR_MOVE AS (
    SELECT YEAR_MONTH
          ,SUM(MONTH_AMT) OVER(ORDER BY YEAR_MONTH ROWS 11 PRECEDING) AS YEAR_MOVE_AMT
      FROM MONTH
     ORDER BY YEAR_MONTH
)

SELECT M.YEAR_MONTH
      ,M.MONTH_AMT
      ,C.CUML_AMT
      ,Y.YEAR_MOVE_AMT
  FROM MONTH AS M
  JOIN CUML AS C ON M.YEAR_MONTH = C.YEAR_MONTH
  JOIN YEAR_MOVE AS Y ON M.YEAR_MONTH = Y.YEAR_MONTH;