SELECT
    d.CHECKUP_DATE AS CK_DATE,
    d.MEMBER_CODE AS CODE,
    m.LAST_NAME || m.FIRST_NAME AS NAME,
    d.CHANGE_WEIGHT AS CHG_WT
FROM (
        SELECT *,
        ROUND(CAST(WEIGHT AS DECIMAL) - CAST(RECENT_PAST_WEIGHT AS DECIMAL), 1) AS CHANGE_WEIGHT
        FROM (
            SELECT *,
                ROW_NUMBER() OVER(PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS REVERSE_ORDER,
                LAG(WEIGHT, 1) OVER(PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE ASC) AS RECENT_PAST_WEIGHT
            FROM HEALTH_CHECKUP
        )
        WHERE REVERSE_ORDER = 1
    ) d
    LEFT OUTER JOIN MEMBER_MST m ON d.MEMBER_CODE = m.MEMBER_CODE
WHERE
    d.CHANGE_WEIGHT <= -5.0 OR 5.0 <= d.CHANGE_WEIGHT
ORDER BY d.CHANGE_WEIGHT DESC, d.MEMBER_CODE DESC