WITH SALES_YM AS(
 SELECT
  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;