WITH RankedCheckups AS (
    SELECT 
        CHECKUP_DATE,
        MEMBER_CODE,
        WEIGHT,
        ROW_NUMBER() OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS rn
    FROM 
        HEALTH_CHECKUP
),
WeightChanges AS (
    SELECT 
        current.CHECKUP_DATE,
        current.MEMBER_CODE,
        current.WEIGHT AS Current_Weight,
        previous.WEIGHT AS Previous_Weight,
        ROUND(current.WEIGHT - previous.WEIGHT, 1) AS Change_Weight
    FROM 
        RankedCheckups current
    JOIN 
        RankedCheckups previous ON current.MEMBER_CODE = previous.MEMBER_CODE AND previous.rn = 2
    WHERE 
        current.rn = 1
)
SELECT 
    CHECKUP_DATE AS CK_DATE,
    MEMBER_CODE AS CODE,
    (SELECT LAST_NAME || FIRST_NAME FROM MEMBER_MST WHERE MEMBER_CODE = w.MEMBER_CODE) AS NAME,
    CASE 
        WHEN Change_Weight = CAST(Change_Weight AS INT) THEN CAST(Change_Weight AS INT)
        ELSE Change_Weight 
    END AS CHG_WT
FROM 
    WeightChanges w
WHERE 
    ABS(w.Change_Weight) >= 5
ORDER BY 
    Change_Weight DESC, 
    MEMBER_CODE DESC;