WITH t AS(
SELECT
    MAX(CHECKUP_DATE)OVER(PARTITION BY hc.member_code) AS CK_DATE
    , hc.MEMBER_CODE AS CODE
    , LAST_NAME || FIRST_NAME AS NAME
    , CHECKUP_DATE
    , ROUND(WEIGHT - LAG(WEIGHT)OVER(PARTITION BY hc.member_code ORDER BY CHECKUP_DATE),1) AS CHG_WT
FROM
    HEALTH_CHECKUP AS hc
LEFT JOIN
    MEMBER_MST AS mm
ON
    hc.member_code = mm.member_code
)
SELECT
    CK_DATE
    , CODE
    , NAME
    , CHG_WT
FROM
    t
WHERE
    CK_DATE = CHECKUP_DATE
    AND ABS(CHG_WT) >= 5
ORDER BY
    CHG_WT DESC
    , CODE DESC