WITH MonthlySales AS (
  SELECT
    STRFTIME('%Y-%m', SALES_DATE) AS YEAR_MONTH,
    SUM(SALES_AMT) AS MONTH_AMT
  FROM
    SALES
  WHERE
    YEAR_MONTH >= '2022-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
WHERE
  YEAR_MONTH BETWEEN '2023-01' AND '2023-12' 
ORDER BY
  YEAR_MONTH ASC;