WITH SALES_AMT AS(
    SELECT SUM(SALES_AMT)
    FROM SALES
    GROUP BY SUBSTR(SALES_DATE,1,7)
)

SELECT
    SUBSTR(SALES_DATE,1,7) AS YEAR_MONTH
    ,SALES_AMT AS MONTH_AMT
    ,SUM(SALES_AMT) AS CUML_AMT
--    ,集計した移動年計金額 AS YEAR_MOVE_AMT
FROM
    SALES
WHERE
    SALES_DATE BETWEEN '2023-01-01' AND '2023-12-31'
    AND UPDATED_NO IS NULL
GROUP BY
    SUBSTR(SALES_DATE,1,7)
ORDER BY
    YEAR_MONTH