SELECT
    FIRST_VALUE(NEW.CHECKUP_DATE) OVER 
        (PARTITION BY NEW.MEMBER_CODE ORDER BY NEW.CHECKUP_DATE DESC) AS CK_DATE
    , NEW.MEMBER_CODE AS CODE
    , MMB.LAST_NAME||MMB.FIRST_NAME AS NAME
    , ROUND(NEW.WEIGHT - OLD.WEIGHT,1) AS CHG_WT
FROM
    HEALTH_CHECKUP NEW
    INNER JOIN HEALTH_CHECKUP OLD
        ON OLD.MEMBER_CODE = NEW.MEMBER_CODE
        AND OLD.CHECKUP_DATE < NEW.CHECKUP_DATE
    INNER JOIN MEMBER_MST MMB USING(MEMBER_CODE)
WHERE
    ABS(ROUND(NEW.WEIGHT - OLD.WEIGHT,1)) >= 5
ORDER BY 4 DESC, 2 DESC;