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
),
Filtered_Checkups AS (
    SELECT 
        c1.MEMBER_CODE, 
        c1.CHECKUP_DATE AS CK_DATE, 
        c1.WEIGHT AS LATEST_WEIGHT, 
        c2.WEIGHT AS PREVIOUS_WEIGHT
    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 
        fc.MEMBER_CODE, 
        fc.CK_DATE, 
        ROUND((fc.LATEST_WEIGHT - fc.PREVIOUS_WEIGHT), 1) AS CHG_WT
    FROM 
        Filtered_Checkups fc
    WHERE 
        ABS(fc.LATEST_WEIGHT - fc.PREVIOUS_WEIGHT) >= 5
)
SELECT 
    wc.CK_DATE, 
    wc.MEMBER_CODE AS CODE, 
    m.LAST_NAME || m.FIRST_NAME AS NAME, 
    CASE 
        WHEN wc.CHG_WT = CAST(wc.CHG_WT AS INT) THEN CAST(wc.CHG_WT AS INT) 
        ELSE wc.CHG_WT 
    END AS CHG_WT
FROM 
    Weight_Changes wc
JOIN 
    MEMBER_MST m 
    ON wc.MEMBER_CODE = m.MEMBER_CODE
ORDER BY 
    wc.CHG_WT DESC, 
    wc.MEMBER_CODE DESC;