with WHT1 as ( 
    select
        MEMBER_CODE
        , CHECKUP_DATE
        , rank() over (partition by MEMBER_CODE order by CHECKUP_DATE desc) as RANK
        , WEIGHT
        from HEALTH_CHECKUP)
select
    CHK.CHECKUP_DATE                            as CK_DATE
    , CHK.MEMBER_CODE                           as CODE
    , MST.LAST_NAME || MST.FIRST_NAME           as NAME
    , (CHK.WEIGHT * 10 - WHT1.WEIGHT * 10) / 10  as CHG_WT 
    from
        HEALTH_CHECKUP as CHK 
    inner join MEMBER_MST as MST 
        on MST.MEMBER_CODE = CHK.MEMBER_CODE 
    inner join WHT1 
        on WHT1.MEMBER_CODE = CHK.MEMBER_CODE 
        and WHT1.RANK = 2 
    where
        CHK.CHECKUP_DATE = (select max(CHECKUP_DATE) from HEALTH_CHECKUP where MEMBER_CODE = CHK.MEMBER_CODE)
        and abs((CHK.WEIGHT * 10 - WHT1.WEIGHT * 10) / 10) >= 5 
        and WHT1.WEIGHT is not null 
    order by
        CHG_WT desc
        , CODE desc;