WITH LatestTwoCheckups AS (
    SELECT 
        H1.MEMBER_CODE,
        H1.CHECKUP_DATE AS LATEST_DATE,
        H1.WEIGHT AS LATEST_WEIGHT,
        H2.CHECKUP_DATE AS PREV_DATE,
        H2.WEIGHT AS PREV_WEIGHT,
        ROW_NUMBER() OVER (PARTITION BY H1.MEMBER_CODE ORDER BY H1.CHECKUP_DATE DESC) AS RN
    FROM 
        HEALTH_CHECKUP H1
    JOIN 
        HEALTH_CHECKUP H2
    ON 
        H1.MEMBER_CODE = H2.MEMBER_CODE
        AND H1.CHECKUP_DATE > H2.CHECKUP_DATE
)
SELECT 
    L.LATEST_DATE AS CK_DATE,
    M.MEMBER_CODE AS CODE,
    M.LAST_NAME || M.FIRST_NAME AS NAME,
    ROUND(L.LATEST_WEIGHT - L.PREV_WEIGHT, 1) AS CHG_WT
FROM 
    LatestTwoCheckups L
JOIN 
    MEMBER_MST M
ON 
    L.MEMBER_CODE = M.MEMBER_CODE
WHERE 
    L.RN = 1
    AND ABS(ROUND(L.LATEST_WEIGHT - L.PREV_WEIGHT, 1)) >= 5
ORDER BY 
    CHG_WT DESC,
    CODE DESC;