WITH MONTH AS(
    SELECT SUBSTR(SALES_DATE,1,7) AS MDATE, SUM(SALES_AMT) AS SAMT
    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)
)
,YEAR AS(
    SELECT MDATE, SUM(SAMT) AS SALES_AMT
    FROM MONTH
    GROUP BY MDATE
)
SELECT
    MDATE AS YEAR_MONTH
    ,SALES_AMT AS MONTH_AMT
--    ,SUM(MONTH.SALES_AMT) AS CUML_AMT
--    ,集計した移動年計金額 AS YEAR_MOVE_AMT
FROM
    YEAR
WHERE
    MDATE BETWEEN '2023-01' AND '2023-12'
GROUP BY
    MDATE
ORDER BY
    YEAR_MONTH