SELECT
    MAX(H1.CHECKUP_DATE) AS CK_DATE,
    H1.MEMBER_CODE AS CODE,
    M.LAST_NAME || M.FIRST_NAME AS NAME,
    H2.CHG_WT_TMP/10.0 AS CHG_WT
FROM HEALTH_CHECKUP AS H1
LEFT JOIN MEMBER_MST AS M ON H1.MEMBER_CODE=M.MEMBER_CODE
NATURAL INNER JOIN
    (SELECT
        CHECKUP_DATE,
        MEMBER_CODE,
        CAST(WEIGHT*10 AS INTEGER) - MIN(CAST(WEIGHT*10 AS INTEGER)) 
                                        OVER(PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE ASC ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS CHG_WT_TMP
    FROM HEALTH_CHECKUP) AS H2
WHERE ABS(CHG_WT)>=5.0
GROUP BY CODE
ORDER BY CHG_WT DESC, CODE DESC;