WITH latest_two_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_checkup AS (
    SELECT
        MEMBER_CODE,
        CHECKUP_DATE AS CK_DATE,
        WEIGHT AS LATEST_WEIGHT
    FROM
        latest_two_checkups
    WHERE
        rn = 1
),
previous_checkup AS (
    SELECT
        MEMBER_CODE,
        WEIGHT AS PREVIOUS_WEIGHT
    FROM
        latest_two_checkups
    WHERE
        rn = 2
),
weight_changes AS (
    SELECT
        lc.MEMBER_CODE,
        lc.CK_DATE,
        ROUND(lc.LATEST_WEIGHT - pc.PREVIOUS_WEIGHT, 1) AS CHG_WT
    FROM
        latest_checkup lc
    JOIN
        previous_checkup pc ON lc.MEMBER_CODE = pc.MEMBER_CODE
    WHERE
        ABS(lc.LATEST_WEIGHT - pc.PREVIOUS_WEIGHT) >= 5
),
member_names AS (
    SELECT
        MEMBER_CODE,
        LAST_NAME || FIRST_NAME AS NAME
    FROM
        MEMBER_MST
)
SELECT
    wc.CK_DATE,
    wc.MEMBER_CODE AS CODE,
    mn.NAME,
    CASE
        WHEN wc.CHG_WT = FLOOR(wc.CHG_WT) THEN CAST(wc.CHG_WT AS INTEGER)
        ELSE wc.CHG_WT
    END AS CHG_WT
FROM
    weight_changes wc
JOIN
    member_names mn ON wc.MEMBER_CODE = mn.MEMBER_CODE
ORDER BY
    wc.CHG_WT DESC,
    wc.MEMBER_CODE DESC;