WITH MONTH_AMT_T AS ( 
    -- 月次売上
    SELECT
        strftime('%Y-%m',SALES_DATE) AS MO年月,
        SUM(SALES_AMT) AS MO金額
    FROM
        SALES AS SLS
    WHERE
        UPDATED_NO is NULL
    GROUP BY
        MO年月
)
,
KIKAN_T AS ( 
    -- 過去１１カ月の集計
    SELECT
        MO年月 as CU年月
       ,MO金額 as MOCU金額
       ,SUM(MO金額) OVER (
           ORDER BY
             -- 年月でソートし11行前までのデータを対象とする
               MO年月 ROWS BETWEEN 11 PRECEDING AND CURRENT ROW

        ) as CU金額
    FROM
        MONTH_AMT_T
)
 
SELECT
     CU年月 AS YEAR_MONTH
    ,MOCU金額 AS MONTH_AMT
   -- SUM OVERで該当月までの売上累計金額を取得する
    ,SUM(MOCU金額) OVER (
            ORDER BY CU年月
     ) AS CUML_AMT
    ,CU金額 as YEAR_MOVE_AMT

FROM
    KIKAN_T
WHERE
    CU年月 BETWEEN '2023-01' AND '2023-12'
ORDER BY
    YEAR_MONTH ASC
    ;