with tmp(YM,pre_YM) as(
values('2022-01-01',null),
      ('2022-02-01','2022-01-01'),
      ('2022-03-01','2022-02-01'),
      ('2022-04-01','2022-03-01'),
      ('2022-05-01','2022-04-01'),
      ('2022-06-01','2022-05-01'),
      ('2022-07-01','2022-06-01'),
      ('2022-08-01','2022-07-01'),
      ('2022-09-01','2022-08-01'),
      ('2022-10-01','2022-09-01'),
      ('2022-11-01','2022-10-01'),
      ('2022-12-01','2022-11-01')
      ),
    
    mrr_temp as (
    select t.YM,
            m.NEW_MRR + m.EXPANSION_MRR - m.DOWNGRADE_MRR - m.CHURN_MRR mrr
    from tmp t
    left join MRR_DATA m
    on t.pre_YM = m.MONTHLY
    ),
    
    mrr_base as (
    select t.YM YM,
            mrr
    from tmp t
    left join mrr_temp m
    on t.YM >= m.YM
    ),
    
    accumulate as (
    select YM,
            sum(mrr) MRR
    from mrr_base
    group by YM
    )
    
select cast(YM as VARCHAR) YM,
        case when MRR is null then 0 else MRR end MRR
from accumulate
order by 1
;