WITH LC AS (
    SELECT
        H.MEMBER_CODE,
        M.LAST_NAME || M.FIRST_NAME AS NAME,
        H.CHECKUP_DATE AS CK_DATE,
        H.WEIGHT,
        ROW_NUMBER() OVER(PARTITION BY H.MEMBER_CODE ORDER BY H.CHECKUP_DATE DESC) AS RN
    FROM
        HEALTH_CHECKUP H
    JOIN
        MEMBER_MST M ON H.MEMBER_CODE = M.MEMBER_CODE
)
SELECT
    LC1.CK_DATE,
    LC1.MEMBER_CODE AS CODE,
    LC1.NAME,
    ROUND(LC1.WEIGHT - LC2.WEIGHT, 1) AS CHG_WT
FROM
    LC LC1
JOIN
    LC LC2 ON LC1.MEMBER_CODE = LC2.MEMBER_CODE AND LC1.RN = 1 AND LC2.RN = 2
WHERE
    ABS(ROUND(LC1.WEIGHT - LC2.WEIGHT, 1)) >= 5
ORDER BY
    CHG_WT DESC,
    CODE DESC;