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