WITH Recent_Checkups AS (
    SELECT 
        CHECKUP_DATE,
        MEMBER_CODE,
        WEIGHT,
        ROW_NUMBER() OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS rn
    FROM 
        HEALTH_CHECKUP
)
SELECT 
    rc1.CHECKUP_DATE AS CK_DATE,
    rc1.MEMBER_CODE AS CODE,
    mst.LAST_NAME || ' ' || mst.FIRST_NAME AS NAME,
    CASE 
        WHEN ROUND(rc1.WEIGHT - rc2.WEIGHT, 1) = CAST(ROUND(rc1.WEIGHT - rc2.WEIGHT, 1) AS INTEGER) 
        THEN CAST(ROUND(rc1.WEIGHT - rc2.WEIGHT, 1) AS INTEGER)
        ELSE ROUND(rc1.WEIGHT - rc2.WEIGHT, 1)
    END AS CHG_WT
FROM 
    Recent_Checkups rc1
JOIN 
    Recent_Checkups rc2
ON 
    rc1.MEMBER_CODE = rc2.MEMBER_CODE 
    AND rc1.rn = 1 
    AND rc2.rn = 2
JOIN 
    MEMBER_MST mst
ON 
    rc1.MEMBER_CODE = mst.MEMBER_CODE
WHERE 
    ABS(rc1.WEIGHT - rc2.WEIGHT) >= 5.0
ORDER BY 
    ABS(rc1.WEIGHT - rc2.WEIGHT) DESC, 
    rc1.MEMBER_CODE DESC;