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;