WITH MON(MY,MONTH_AMT) AS (
    SELECT SUBSTR(SALES_DATE,1,7) , SUM(SALES_AMT)
    FROM SALES
    WHERE UPDATED_NO IS NULL
    GROUP BY SUBSTR(SALES_DATE,1,7)
),CUM(CY,CUML_AMT) AS(
    SELECT MY, SUM(MONTH_AMT) OVER(ORDER BY MY)
    FROM MON 
    WHERE MY >= '2023-01'
), summ(y,su) as(
    select my,SUM(MONTH_AMT)OVER(ORDER BY MY ROWS 11 PRECEDING)
    FROM MON
)
SELECT MY YEAR_MONTH,MONTH_AMT,CUML_AMT,su YEAR_MOVE_AMT
FROM MON JOIN CUM ON(MY = CY) JOIN summ ON(MY = y)
WHERE MY BETWEEN '2023-01' AND '2023-12'
ORDER BY MY