WITH RankedCheckups AS (
    SELECT 
        hc.CHECKUP_DATE,
        hc.MEMBER_CODE,
        hc.WEIGHT,
        (SELECT COUNT(*) 
         FROM HEALTH_CHECKUP AS hc2 
         WHERE hc2.MEMBER_CODE = hc.MEMBER_CODE AND hc2.CHECKUP_DATE >= hc.CHECKUP_DATE) AS rn
    FROM 
        HEALTH_CHECKUP hc
),
WeightChanges AS (
    SELECT 
        c1.CHECKUP_DATE AS CK_DATE,
        c1.MEMBER_CODE AS CODE,
        (SELECT LAST_NAME || FIRST_NAME 
         FROM MEMBER_MST m 
         WHERE m.MEMBER_CODE = c1.MEMBER_CODE) AS NAME,
        ROUND(c1.WEIGHT - c2.WEIGHT, 1) AS CHG_WT
    FROM 
        RankedCheckups c1
    JOIN 
        RankedCheckups c2 ON c1.MEMBER_CODE = c2.MEMBER_CODE AND c2.rn = c1.rn + 1
    WHERE 
        c1.rn = 1 
        AND ABS(c1.WEIGHT - c2.WEIGHT) >= 5
)
SELECT 
    CK_DATE,
    CODE,
    NAME,
    CASE 
        WHEN CHG_WT = ROUND(CHG_WT) THEN ROUND(CHG_WT)
        ELSE CHG_WT 
    END AS CHG_WT
FROM 
    WeightChanges
ORDER BY 
    CHG_WT DESC, CODE DESC;