SELECT
    HC2.CHECKUP_DATE AS CK_DATE,
    HC2.MEMBER_CODE AS CODE,
    (M.LAST_NAME || M.FIRST_NAME) AS NAME,
    ROUND(HC2.WEIGHT - HC1.WEIGHT, 1) AS CHG_WT
FROM
    HEALTH_CHECKUP HC1
JOIN
    HEALTH_CHECKUP HC2 ON HC1.MEMBER_CODE = HC2.MEMBER_CODE AND HC1.CHECKUP_DATE < HC2.CHECKUP_DATE
JOIN
    MEMBER_MST M ON HC2.MEMBER_CODE = M.MEMBER_CODE
WHERE
    HC2.CHECKUP_DATE = (
        SELECT
            MAX(CHECKUP_DATE)
        FROM
            HEALTH_CHECKUP
        WHERE
            MEMBER_CODE = HC2.MEMBER_CODE)
    AND HC1.CHECKUP_DATE = (
        SELECT
            MAX(CHECKUP_DATE)
        FROM
            HEALTH_CHECKUP
        WHERE
            MEMBER_CODE = HC1.MEMBER_CODE AND CHECKUP_DATE < HC2.CHECKUP_DATE)
    AND CHG_WT <= -5 OR 5 <= CHG_WT
ORDER BY
    CHG_WT DESC,
    CODE DESC;