WITH
ym_stats AS (
    SELECT
        SUBSTR(SALES_DATE, 0, 8) AS YEAR_MONTH,
        SUM(SALES_AMT) AS TOTAL_AMT
    FROM
        SALES
    WHERE
        UPDATED_NO IS NULL
    GROUP BY
        YEAR_MONTH
),
ym_stats_add_move_amt AS (
    SELECT
        *,
        -- 該当月に過去11カ月の売り上げ累計を合計
        SUM(TOTAL_AMT) OVER(ORDER BY YEAR_MONTH ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) AS YEAR_MOVE_AMT
    FROM
        ym_stats
)

SELECT
    YEAR_MONTH,
    SUM(TOTAL_AMT) OVER(ORDER BY YEAR_MONTH) AS MONTH_AMT,
    YEAR_MOVE_AMT
FROM
    ym_stats_add_move_amt
WHERE
    YEAR_MONTH BETWEEN "2023-01" AND "2023-12"
ORDER BY
    YEAR_MONTH