with md1 as (
select md.MONTHLY as MONTHLY,
case md.MONTHLY when MIN(md.MONTHLY)
    THEN true
    ELSE false 
END as OLD,
case md.MONTHLY when MAX(md.MONTHLY)
    THEN true
    ELSE false
END as LATEST
from MRR_DATA as md
order by md.MONTHLY
)

with md2 as (
select md.MONTHLY as MONTHLY,
case when DATE_ADD(md.MONTHLY, INTERVAL 1 MONTH) in (select md.MONTHLY from from MRR_DATA as md)
    THEN true
    ELSE false 
END as OLD,
case md.MONTHLY when MAX(md.MONTHLY)
    THEN true
    ELSE false
END as LATEST
from MRR_DATA as md
order by md.MONTHLY
)

select md1.MONTHLY as YM, 
from MRR_DATA as md
JOIN md1 ON md1.MONTHLY = md.MONTHLY