WITH SALES_YM AS(
    -- 月ごとに売上金額を集計
    SELECT
        -- 売上日をYYYY-MMの形式に変換
        STRFTIME('%Y-%m', SALES_DATE) AS YM
        , SUM(SALES_AMT) AS MON_AMT
    FROM
        SALES
    WHERE
        YM >= '2022-01'
        AND UPDATED_NO IS NULL
    GROUP BY
        YM
)
, Z_CHART AS(
    SELECT
        YM AS YEAR_MONTH
        , MON_AMT AS MONTH_AMT
        , SUM(MON_AMT) OVER (
            ORDER BY
                YM ROWS BETWEEN 11 PRECEDING AND CURRENT ROW
        ) AS YEAR_MOVE_AMT
    FROM
        SALES_YM
)
SELECT
    YEAR_MONTH
    , MONTH_AMT
    , SUM(MONTH_AMT) OVER (ORDER BY YEAR_MONTH) AS CUML_AMT
    , YEAR_MOVE_AMT
FROM
    Z_CHART
WHERE
    YEAR_MONTH BETWEEN '2023-01' AND '2023-12'
ORDER BY
    YEAR_MONTH ASC;