select
    max(CHK.CHECKUP_DATE)                           as CK_DATE
    , CHK.MEMBER_CODE                               as CODE
    , MST.LAST_NAME || MST.FIRST_NAME               as NAME
    , round(CHK.WEIGHT - 
        (select
                CHK2.WEIGHT 
            from
                HEALTH_CHECKUP as CHK2 
            where
                CHK2.MEMBER_CODE = CHK.MEMBER_CODE 
                and CHK2.CHECKUP_DATE < CHK.CHECKUP_DATE 
            limit 1)
            , 2)                                   as CHG_WT 
from
    HEALTH_CHECKUP as CHK 
    inner join MEMBER_MST as MST 
        on MST.MEMBER_CODE = CHK.MEMBER_CODE 
where
    abs(CHG_WT) >= 5 
group by
    CODE 
order by
    CHG_WT desc
    , CODE desc;