with newest as(
select
    a.MEMBER_CODE as CODE
    ,b.LAST_NAME || b.FIRST_NAME as NAME
    ,max(a.CHECKUP_DATE) as CK_DATE
from
    HEALTH_CHECKUP a
left join
    MEMBER_MST b
on
    a.MEMBER_CODE = b.MEMBER_CODE
group by
    1,2
)
, second_new as(
select
    a.MEMBER_CODE as CODE
    ,max(a.CHECKUP_DATE) as CK_DATE2
from
    HEALTH_CHECKUP a
left join
    MEMBER_MST b
on
    a.MEMBER_CODE = b.MEMBER_CODE
left join
    newest c
on
    a.MEMBER_CODE = c.CODE and a.CHECKUP_DATE = c.CK_DATE
where
    c.CK_DATE is null
group by
    1
)
select
    a.CK_DATE
    ,a.CODE
    ,a.NAME
    ,round(c.WEIGHT - d.WEIGHT, 1) as CHG_WT
from
    newest a
left join
    second_new b
on
    a.CODE = b.CODE
left join
    HEALTH_CHECKUP c
on
    a.CODE = c.MEMBER_CODE and a.CK_DATE = c.CHECKUP_DATE
left join
    HEALTH_CHECKUP d
on
    a.CODE = d.MEMBER_CODE and b.CK_DATE2 = d.CHECKUP_DATE
where
    abs(round(c.WEIGHT - d.WEIGHT, 1)) >= 5
order by
    4 desc, 2 desc
;