WITH LATEST_CHECKUPS AS (
    SELECT 
        MEMBER_CODE,
        CHECKUP_DATE,
        WEIGHT,
        ROW_NUMBER() OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS RN
    FROM 
        HEALTH_CHECKUP
),
LATEST_TWO_CHECKUPS AS (
    SELECT 
        MEMBER_CODE,
        MAX(CASE WHEN RN = 1 THEN CHECKUP_DATE END) AS CK_DATE,
        MAX(CASE WHEN RN = 1 THEN WEIGHT END) AS LATEST_WEIGHT,
        MAX(CASE WHEN RN = 2 THEN WEIGHT END) AS PREVIOUS_WEIGHT
    FROM 
        LATEST_CHECKUPS
    WHERE 
        RN <= 2
    GROUP BY 
        MEMBER_CODE
)
SELECT 
    L.CK_DATE,
    L.MEMBER_CODE AS CODE,
    M.LAST_NAME || M.FIRST_NAME AS NAME,
    CASE 
        WHEN round(ABS(L.LATEST_WEIGHT - L.PREVIOUS_WEIGHT) - FLOOR(ABS(L.LATEST_WEIGHT - L.PREVIOUS_WEIGHT))) = 0 
        THEN CAST(ROUND(ABS(L.LATEST_WEIGHT - L.PREVIOUS_WEIGHT)) AS INT)
        ELSE round(ABS(L.LATEST_WEIGHT - L.PREVIOUS_WEIGHT))
    END AS CHG_WT
FROM 
    LATEST_TWO_CHECKUPS L
JOIN 
    MEMBER_MST M ON L.MEMBER_CODE = M.MEMBER_CODE
WHERE 
    ABS(L.LATEST_WEIGHT - L.PREVIOUS_WEIGHT) >= 5
ORDER BY 
    CHG_WT DESC,
    CODE DESC;