WITH latest_checkups AS (
    SELECT 
        MEMBER_CODE, 
        CHECKUP_DATE, 
        WEIGHT,
        ROW_NUMBER() OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS rn
    FROM 
        HEALTH_CHECKUP
),
checkup_pairs AS (
    SELECT 
        c1.MEMBER_CODE, 
        c1.CHECKUP_DATE AS CK_DATE, 
        c1.WEIGHT AS WEIGHT_LATEST,
        c2.WEIGHT AS WEIGHT_PREV
    FROM 
        latest_checkups c1
    JOIN 
        latest_checkups c2
    ON 
        c1.MEMBER_CODE = c2.MEMBER_CODE AND c1.rn = 1 AND c2.rn = 2
),
weight_changes AS (
    SELECT 
        cp.MEMBER_CODE,
        cp.CK_DATE,
        m.LAST_NAME || m.FIRST_NAME AS NAME,
        ROUND(cp.WEIGHT_LATEST - cp.WEIGHT_PREV, 1) AS CHG_WT
    FROM 
        checkup_pairs cp
    JOIN 
        MEMBER_MST m
    ON 
        cp.MEMBER_CODE = m.MEMBER_CODE
    WHERE 
        ABS(cp.WEIGHT_LATEST - cp.WEIGHT_PREV) >= 5
)
SELECT 
    CK_DATE, 
    MEMBER_CODE AS CODE, 
    NAME, 
    CHG_WT
FROM 
    weight_changes
ORDER BY 
    CHG_WT DESC,
    MEMBER_CODE DESC;