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
),
Filtered_Checkups AS (
    SELECT
        L1.MEMBER_CODE,
        L1.CHECKUP_DATE AS CK_DATE,
        L1.WEIGHT AS LATEST_WEIGHT,
        L2.WEIGHT AS PREVIOUS_WEIGHT
    FROM
        Latest_Checkups L1
    JOIN
        Latest_Checkups L2 ON L1.MEMBER_CODE = L2.MEMBER_CODE AND L1.rn = 1 AND L2.rn = 2
),
Weight_Changes AS (
    SELECT
        FC.MEMBER_CODE,
        FC.CK_DATE,
        M.LAST_NAME || M.FIRST_NAME AS NAME,
        ROUND(FC.LATEST_WEIGHT - FC.PREVIOUS_WEIGHT, 1) AS CHG_WT
    FROM
        Filtered_Checkups FC
    JOIN
        MEMBER_MST M ON FC.MEMBER_CODE = M.MEMBER_CODE
    WHERE
        ABS(FC.LATEST_WEIGHT - FC.PREVIOUS_WEIGHT) >= 5
)
SELECT
    WC.CK_DATE,
    WC.MEMBER_CODE AS CODE,
    WC.NAME,
    CASE 
        WHEN WC.CHG_WT = ROUND(WC.CHG_WT) THEN CAST(WC.CHG_WT AS INTEGER)
        ELSE WC.CHG_WT
    END AS CHG_WT
FROM
    Weight_Changes WC
ORDER BY
    WC.CHG_WT DESC,
    WC.MEMBER_CODE DESC;