select
YM as YM
,sum(mrr) over(order by YM) as MRR
from(
    select
    monthly as YM
    ,strftime(DATE(monthly,'localtime','+1 MONTH')) as prev2
    ,ifnull(prev_new_mrr+prev_expansion_mrr-prev_downgrade_mrr-prev_churn_mrr,0) as MRR
            ,new_mrr as prev_new_mrr
        ,expansion_mrr as prev_expansion_mrr
        ,downgrade_mrr as prev_downgrade_mrr
        ,churn_mrr as prev_churn_mrr
    from mrr_data as m1
    left outer join(
        select
        strftime(DATE(monthly,'localtime','+1 MONTH')) as prev
        ,new_mrr as prev_new_mrr
        ,expansion_mrr as prev_expansion_mrr
        ,downgrade_mrr as prev_downgrade_mrr
        ,churn_mrr as prev_churn_mrr
        from mrr_data
    ) as m2
    on m1.monthly = m2.prev
)as m0
order by YM