With SUM_MRR AS(
	SELECT
		 strftime('%Y-%m-%d',datetime(MONTHLY,'-1 month')) YM
		,NEW_MRR + EXPANSION_MRR - DOWNGRADE_MRR - CHURN_MRR MRR
	FROM MRR_DATA
),
LAST_MRR AS (
	SELECT
		 MONTHLY YM
		,SUM_MRR.MRR + NEW_MRR + EXPANSION_MRR - DOWNGRADE_MRR - CHURN_MRR MRR
	FROM MRR_DATA MD
		,SUM_MRR
	WHERE SUM_MRR.YM = strftime('%Y-%m-%d',datetime(MD.MONTHLY,'-1 month'))
)
SELECT
	 strftime('%Y-%m-%d',datetime(MONTHLY,'1 month')) YM
	,LAST_MRR.MRR MRR
FROM MRR_DATA MD
	,LAST_MRR
WHERE LAST_MRR.YM = MD.MONTHLY
ORDER BY MD.MONTHLY