SELECT
      tmp.CHECKUP_DATE CK_DATE
    , tmp.MEMBER_CODE CODE
    , tmp.name NAME
    , tmp.diff CHG_WT 
FROM
    ( 
        SELECT
              hp.CHECKUP_DATE
            , hp.MEMBER_CODE
            , mm.LAST_NAME || mm.FIRST_NAME name
            , round( 
                hp.WEIGHT - max(hp.WEIGHT) OVER ( 
                    PARTITION BY
                        hp.MEMBER_CODE 
                    ORDER BY
                        hp.CHECKUP_DATE DESC ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING
                ) 
                , 2
            ) diff
            , row_number() OVER ( 
                PARTITION BY
                    hp.MEMBER_CODE 
                ORDER BY
                    hp.CHECKUP_DATE DESC
            ) num 
        FROM
            HEALTH_CHECKUP hp 
            INNER JOIN MEMBER_MST mm 
                ON hp.MEMBER_CODE = mm.MEMBER_CODE
    ) tmp 
WHERE
    tmp.num = 1 
    AND abs(tmp.diff) >= 5 
ORDER BY
    tmp.diff DESC
    , tmp.MEMBER_CODE DESC
;