WITH Latest_Checkup AS (
    SELECT
        h1.MEMBER_CODE,
        h1.CHECKUP_DATE AS LATEST_DATE,
        h1.WEIGHT AS LATEST_WEIGHT,
        h2.CHECKUP_DATE AS PREVIOUS_DATE,
        h2.WEIGHT AS PREVIOUS_WEIGHT
    FROM
        HEALTH_CHECKUP h1
        JOIN HEALTH_CHECKUP h2 ON h1.MEMBER_CODE = h2.MEMBER_CODE
    WHERE
        h1.CHECKUP_DATE = (
            SELECT MAX(h3.CHECKUP_DATE)
            FROM HEALTH_CHECKUP h3
            WHERE h3.MEMBER_CODE = h1.MEMBER_CODE
        )
        AND h2.CHECKUP_DATE = (
            SELECT MAX(h4.CHECKUP_DATE)
            FROM HEALTH_CHECKUP h4
            WHERE h4.MEMBER_CODE = h1.MEMBER_CODE
            AND h4.CHECKUP_DATE < h1.CHECKUP_DATE
        )
),
Weight_Changes AS (
    SELECT
        lc.MEMBER_CODE,
        lc.LATEST_DATE AS CK_DATE,
        (lc.LATEST_WEIGHT - lc.PREVIOUS_WEIGHT) AS CHG_WT
    FROM
        Latest_Checkup lc
    WHERE
        ABS(lc.LATEST_WEIGHT - lc.PREVIOUS_WEIGHT) >= 5
)
SELECT
    wc.CK_DATE,
    wc.MEMBER_CODE AS CODE,
    m.LAST_NAME || m.FIRST_NAME AS NAME,
    CASE
        WHEN wc.CHG_WT = ROUND(wc.CHG_WT) THEN ROUND(wc.CHG_WT)
        ELSE wc.CHG_WT
    END AS CHG_WT
FROM
    Weight_Changes wc
    JOIN MEMBER_MST m ON wc.MEMBER_CODE = m.MEMBER_CODE
ORDER BY
    ABS(wc.CHG_WT) DESC,
    wc.MEMBER_CODE DESC;