WITH RECURSIVE latest_next_ym AS (SELECT DATE(MAX(MONTHLY), '+1 month') FROM MRR_DATA),
mrr_monthly(YM, MRR) AS (
    SELECT MIN(MONTHLY) YM, 0 MRR FROM MRR_DATA
    UNION ALL
    SELECT
        DATE(YM, '+1 month') YM,
        (
            CASE WHEN EXISTS(SELECT MONTHLY FROM MRR_DATA WHERE MONTHLY = YM)
            THEN MRR + (SELECT NEW_MRR + EXPANSION_MRR  - DOWNGRADE_MRR - CHURN_MRR FROM MRR_DATA WHERE MONTHLY = YM)
            ELSE 0
            END
        ) MRR
    FROM mrr_monthly
    WHERE YM < (SELECT * FROM latest_next_ym)
)
SELECT * FROM mrr_monthly
ORDER BY YM ASC