WITH MonthlySales AS (
  SELECT
    STRFTIME('%Y-%m', SALES_DATE) AS YEAR_MONTH,
    SUM(SALES_AMT) AS MONTH_AMT
  FROM
    SALES
  WHERE
    SALES_DATE BETWEEN '2023-01' AND '2024-01'
    AND UPDATED_NO IS NULL
  GROUP BY
    YEAR_MONTH
), CumulativeSales AS (
  SELECT
    YEAR_MONTH,
    MONTH_AMT,
    SUM(MONTH_AMT) OVER (ORDER BY YEAR_MONTH ASC) AS CUML_AMT
  FROM
    MonthlySales
), RollingYearSales AS (
  SELECT
    YEAR_MONTH,
    MONTH_AMT,
    CUML_AMT,
    SUM(MONTH_AMT) OVER (ORDER BY YEAR_MONTH ASC ROWS BETWEEN 11 PRECEDING AND CURRENT ROW) AS YEAR_MOVE_AMT
  FROM
    CumulativeSales
)
SELECT
  YEAR_MONTH,
  MONTH_AMT,
  CUML_AMT,
  YEAR_MOVE_AMT
FROM
  RollingYearSales
ORDER BY
  YEAR_MONTH ASC;