WITH MonthlySales AS (
    SELECT
        strftime('%Y-%m', SALES_DATE) AS YEAR_MONTH,
        SUM(SALES_AMT) AS MONTH_AMT
    FROM
        SALES
    WHERE
        -- SALES_TYPE != 2 AND -- 売上返品を除外
        UPDATED_NO IS NULL -- 黒伝のみを対象
        -- SALES_DATE BETWEEN '2023-01-01' AND '2023-12-31'
    GROUP BY
        YEAR_MONTH
),
CumulativeSales AS (
    SELECT
        m.YEAR_MONTH,
        m.MONTH_AMT,
        (SELECT SUM(MONTH_AMT) FROM MonthlySales WHERE YEAR_MONTH <= m.YEAR_MONTH) AS CUML_AMT,
        (SELECT SUM(MONTH_AMT) FROM MonthlySales WHERE YEAR_MONTH BETWEEN '2023-01' AND m.YEAR_MONTH) AS CUML_AMT2
    FROM
        MonthlySales m
),
MovingYearTotal AS (
    SELECT
        c.YEAR_MONTH,
        c.MONTH_AMT,
        c.CUML_AMT2,
        (SELECT SUM(MONTH_AMT) FROM MonthlySales WHERE YEAR_MONTH BETWEEN 
            strftime('%Y-%m', date(c.YEAR_MONTH || '-01', '-11 month')) AND c.YEAR_MONTH) AS YEAR_MOVE_AMT
    FROM
        CumulativeSales c
)
SELECT
    YEAR_MONTH,
    MONTH_AMT,
    CUML_AMT2 as CUML_AMT,
    YEAR_MOVE_AMT
FROM
    MovingYearTotal
WHERE YEAR_MONTH BETWEEN '2023-01' AND '2023-12'
ORDER BY
    YEAR_MONTH;