WITH RECURSIVE mrr_recursive AS (
  SELECT MONTHLY, NEW_MRR, EXPANSION_MRR, DOWNGRADE_MRR, CHURN_MRR,
         (NEW_MRR + EXPANSION_MRR - DOWNGRADE_MRR - CHURN_MRR) AS MRR
  FROM MRR_DATA
  WHERE MONTHLY = (SELECT MIN(MONTHLY) FROM MRR_DATA)
  
  UNION ALL
  
  SELECT t.MONTHLY, t.NEW_MRR, t.EXPANSION_MRR, t.DOWNGRADE_MRR, t.CHURN_MRR,
         (r.MRR + t.NEW_MRR + t.EXPANSION_MRR - t.DOWNGRADE_MRR - t.CHURN_MRR) AS MRR
  FROM MRR_DATA AS t
  JOIN mrr_recursive AS r ON SUBSTR(t.MONTHLY, 1, 7) = SUBSTR(r.MONTHLY, 1, 7, ) || '-01'
)
SELECT MONTHLY AS YM, MRR
FROM mrr_recursive
ORDER BY MONTHLY ASC;