WITH LatestCheckups AS (
    SELECT 
        CHECKUP_DATE,
        MEMBER_CODE,
        WEIGHT,
        ROW_NUMBER() OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS rn
    FROM 
        HEALTH_CHECKUP
),
CheckupPairs AS (
    SELECT 
        c1.MEMBER_CODE,
        c1.CHECKUP_DATE AS LATEST_CHECKUP_DATE,
        c1.WEIGHT AS LATEST_WEIGHT,
        c2.CHECKUP_DATE AS PREVIOUS_CHECKUP_DATE,
        c2.WEIGHT AS PREVIOUS_WEIGHT,
        c1.WEIGHT - c2.WEIGHT AS WEIGHT_DIFF
    FROM 
        LatestCheckups c1
    JOIN 
        LatestCheckups c2
    ON 
        c1.MEMBER_CODE = c2.MEMBER_CODE
        AND c1.rn = 1
        AND c2.rn = 2
)
SELECT 
    cp.LATEST_CHECKUP_DATE AS CK_DATE,
    m.MEMBER_CODE AS CODE,
    m.LAST_NAME || m.FIRST_NAME AS NAME,
    CASE 
        WHEN cp.WEIGHT_DIFF = ROUND(cp.WEIGHT_DIFF) THEN CAST(cp.WEIGHT_DIFF AS INTEGER)
        ELSE ROUND(cp.WEIGHT_DIFF, 1)
    END AS CHG_WT
FROM 
    CheckupPairs cp
JOIN 
    MEMBER_MST m
ON 
    cp.MEMBER_CODE = m.MEMBER_CODE
WHERE 
    ABS(cp.WEIGHT_DIFF) >= 4.9999999999999
ORDER BY 
    cp.WEIGHT_DIFF DESC,
    cp.MEMBER_CODE DESC;