with MRR1 as(
select 
strftime('%Y-%m-%d' ,mr1.MONTHLY) as "YM",
sum(ifnull(mr2.NEW_MRR,0) + ifnull(mr2.EXPANSION_MRR,0) - ifnull(mr2.DOWNGRADE_MRR,0) - ifnull(mr2.CHURN_MRR,0)) over(order by mr1.MONTHLY) as MRR
from MRR_DATA as mr1
left join MRR_DATA as mr2 on datetime(mr2.MONTHLY, '+1 months') = datetime(mr1.MONTHLY)
order by mr1.MONTHLY
)
select * from MRR1
union all
select strftime('%Y-%m-%d' ,datetime(YM, '+1 months')),
MRR + ifnull(NEW_MRR,0) + ifnull(EXPANSION_MRR,0) - ifnull(DOWNGRADE_MRR,0) - ifnull(CHURN_MRR,0) 
from MRR1
inner join MRR_DATA on MRR1.YM = MRR_DATA.MONTHLY
where YM = (select max(YM) from MRR1)
order by MRR1.YM