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