WITH 
HEALTH_CHECKUP_NUM AS (
SELECT 
    ROW_NUMBER() OVER (PARTITION BY MEMBER_CODE ORDER BY WT1.CHECKUP_DATE DESC) AS NO,
    WT1.*
FROM
    HEALTH_CHECKUP WT1
)
SELECT 
    T1.CHECKUP_DATE AS CK_DATE,
    T1.MEMBER_CODE AS CODE,
    T3.LAST_NAME || T3.FIRST_NAME AS NAME,
    ROUND(T1.WEIGHT -T2.WEIGHT,1) AS CHG_WT
FROM 
    HEALTH_CHECKUP_NUM T1
INNER JOIN
    HEALTH_CHECKUP_NUM T2
ON
    T2.MEMBER_CODE  = T1.MEMBER_CODE
AND T2.NO = 2
LEFT OUTER JOIN
    MEMBER_MST T3
ON
    T3.MEMBER_CODE = T1.MEMBER_CODE
WHERE
    ABS( ROUND(T1.WEIGHT -T2.WEIGHT,1) ) >= 5 
AND T1.NO = 1
ORDER BY
    ROUND(T1.WEIGHT -T2.WEIGHT,1) DESC,
    T1.MEMBER_CODE DESC