WITH A AS (
SELECT
  	SUBSTR(A.SALES_DATE, 1, 7) AS YEAR_MONTH
  	,SUM(A.SALES_AMT) AS MONTH_AMT
  	,1 AS CUML_AMT
  	,1 AS YEAR_MOVE_AMT
FROM SALES A
WHERE A.SALES_DATE BETWEEN '2023-01-01' AND '2023-12-31'
AND A.UPDATED_NO IS NULL
GROUP BY YEAR_MONTH)
,
B AS (
    SELECT 
        YEAR_MONTH,
        MONTH_AMT,
        SUM(MONTH_AMT) OVER (ORDER BY YEAR_MONTH) AS CUML_AMT
    FROM A
)
,
C 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 B
)

SELECT 
    C.YEAR_MONTH,
    C.MONTH_AMT,
    B.CUML_AMT,
    C.YEAR_MOVE_AMT
FROM C c
JOIN B b ON c.YEAR_MONTH = b.YEAR_MONTH;