WITH RECURSIVE Months(YEAR_MONTH) AS (
  SELECT '2023-01' UNION ALL
  SELECT STRFTIME('%Y-%m', DATE(YEAR_MONTH || '-01', '+1 month'))
  FROM Months
  WHERE YEAR_MONTH < '2023-12'
),
MonthlySales AS (
  SELECT
    STRFTIME('%Y-%m', SALES_DATE) AS YEAR_MONTH,
    SUM(SALES_AMT) AS MONTH_AMT
  FROM
    SALES
  WHERE
    SALES_TYPE != 2 AND UPDATED_NO IS NULL AND STRFTIME('%Y', SALES_DATE) = '2023'
  GROUP BY
    YEAR_MONTH
),
CumulativeSales AS (
  SELECT
    M.YEAR_MONTH,
    COALESCE(MS.MONTH_AMT, 0) AS MONTH_AMT,
    SUM(COALESCE(MS2.MONTH_AMT, 0)) OVER (ORDER BY M.YEAR_MONTH) AS CUML_AMT
  FROM
    Months M
  LEFT JOIN MonthlySales MS ON M.YEAR_MONTH = MS.YEAR_MONTH
  LEFT JOIN MonthlySales MS2 ON MS2.YEAR_MONTH <= M.YEAR_MONTH
),
MovingYearTotal AS (
  SELECT
    CS.YEAR_MONTH,
    CS.MONTH_AMT,
    CS.CUML_AMT,
    (SELECT SUM(COALESCE(MS.MONTH_AMT, 0)) FROM MonthlySales MS
     WHERE MS.YEAR_MONTH BETWEEN STRFTIME('%Y-%m', DATE(CS.YEAR_MONTH || '-01', '-11 month')) AND CS.YEAR_MONTH) AS YEAR_MOVE_AMT
  FROM
    CumulativeSales CS
)
SELECT distinct
  YEAR_MONTH,
  MONTH_AMT,
  CUML_AMT,
  YEAR_MOVE_AMT
FROM
  MovingYearTotal
ORDER BY
  YEAR_MONTH;