WITH MONTHLY 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
        YEAR_MONTH
    )
SELECT
    CUML.YEAR_MONTH
    ,CUML.MONTH_AMT
    ,CUML.CUML_AMT
    ,MOVE.YEAR_MOVE_AMT
FROM
    (
    -- 売上累計を集計
    SELECT
        YEAR_MONTH
        ,MONTH_AMT
        ,SUM(CASE WHEN YEAR_MONTH LIKE '2023-%' THEN MONTH_AMT END) OVER(ORDER BY YEAR_MONTH
         ROWS UNBOUNDED PRECEDING
        ) AS CUML_AMT
    FROM
        MONTHLY
    GROUP BY
        YEAR_MONTH
        ,MONTH_AMT
    ) AS CUML
LEFT JOIN
    (
    -- 移動年計を集計
    SELECT
        YEAR_MONTH
        ,SUM(MONTH_AMT) OVER(ORDER BY YEAR_MONTH ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) AS YEAR_MOVE_AMT
    FROM
        MONTHLY
    GROUP BY
        YEAR_MONTH
    ) AS MOVE
ON
    CUML.YEAR_MONTH = MOVE.YEAR_MONTH
WHERE
    CUML.YEAR_MONTH LIKE '2023%'
ORDER BY
    CUML.YEAR_MONTH