with a as (
select * from MRR_DATA
union all
select 
 date(max(MONTHLY),'+1 months'),0,0,0,0 
from MRR_DATA
)
select 
    MONTHLY as YM,
    coalesce(sum(NEW_MRR) OVER (ORDER BY MONTHLY rows between unbounded preceding and 1 preceding)  
    + sum(EXPANSION_MRR) OVER (ORDER BY MONTHLY rows between unbounded preceding and 1 preceding)
    - sum(DOWNGRADE_MRR) OVER (ORDER BY MONTHLY rows between unbounded preceding and 1 preceding)
    - sum(CHURN_MRR) OVER (ORDER BY MONTHLY rows between unbounded preceding and 1 preceding),0) as MRR
from a
order by 1