--取得データ整理
WITH FIX_SALES AS
(SELECT
STRFTIME('%Y-%m', SALES_DATE) AS YEAR_MONTH,
SUM(SALES_AMT) AS MONTH_AMT,
STRFTIME('%Y', SALES_DATE) AS YEAR
FROM
SALES
WHERE UPDATED_NO IS NULL
GROUP BY YEAR_MONTH),

--各数値集計
CULC AS 
(SELECT
YEAR_MONTH,
MONTH_AMT,
SUM(MONTH_AMT)
OVER(
PARTITION BY YEAR
ORDER BY YEAR_MONTH
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS CUML_AMT,
SUM(MONTH_AMT)
OVER(
ORDER BY YEAR_MONTH
ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) AS YEAR_MOVE_AMT
FROM
FIX_SALES)

--まとめ
SELECT
*
FROM CULC
WHERE YEAR_MONTH BETWEEN '2023-01' AND '2023-12'
ORDER BY YEAR_MONTH
;