WITH TMP (CK_DATE, CODE, CHG_WT) AS (
    SELECT
        CHECKUP_DATE AS CK_DATE
        , MEMBER_CODE AS CODE
        , ROUND(
            WEIGHT - LEAD(WEIGHT) OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC)
            , 1
        ) AS CHG_WT
    FROM
        HEALTH_CHECKUP
)
SELECT
    CK_DATE
    , CODE
    , (SELECT LAST_NAME || FIRST_NAME FROM MEMBER_MST WHERE MEMBER_CODE = CODE) AS NAME
    , CHG_WT
FROM
    TMP
WHERE
    CK_DATE = (
        SELECT MAX(CK_DATE) FROM TMP AS SUB WHERE SUB.CODE = TMP.CODE
    )
    AND ABS(CHG_WT) >= 5
ORDER BY
    CHG_WT DESC, CODE DESC