WITH 
LAST(LAST_MONTH)
AS(
    SELECT MONTHLY
    FROM MRR_DATA
    UNION
	SELECT date(MONTHLY,'-1 months')
	FROM MRR_DATA
  ),
EXMRR_DATA
AS(
    SELECT * 
    FROM LAST left join MRR_DATA on MONTHLY = LAST_MONTH
  ),
CAL
AS(
    SELECT MIN(MONTHLY) AS YM,0 AS MRR
    FROM EXMRR_DATA
    UNION ALL
    SELECT date(YM,'+1 months'),
           MRR + (SELECT NEW_MRR+EXPANSION_MRR-DOWNGRADE_MRR-CHURN_MRR
                  FROM EXMRR_DATA
                  WHERE MONTHLY = YM
           )
    FROM CAL
    WHERE YM <= (SELECT date(MAX(MONTHLY)) FROM EXMRR_DATA)
    )
   
SELECT *
FROM CAL
ORDER BY YM