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 
    current.CHECKUP_DATE AS CK_DATE,
    current.MEMBER_CODE AS CODE,
    mst.LAST_NAME || ' ' || mst.FIRST_NAME AS NAME,
    ROUND(ABS(current.WEIGHT - previous.WEIGHT), 1) AS CHG_WT
FROM 
    Recent_Checkups current
JOIN 
    Recent_Checkups previous
ON 
    current.MEMBER_CODE = previous.MEMBER_CODE 
    AND current.rn = 1 
    AND previous.rn = 2
JOIN 
    MEMBER_MST mst
ON 
    current.MEMBER_CODE = mst.MEMBER_CODE
WHERE 
    ROUND(ABS(current.WEIGHT - previous.WEIGHT), 1) >= 5.0
ORDER BY 
    CHG_WT DESC, 
    CODE DESC;