WITH
    latest AS (
        SELECT
            CHECKUP_DATE AS CHECKUP_DATE,
            MEMBER_CODE AS MEMBER_CODE,
            WEIGHT AS WEIGHT,
            ROW_NUMBER() OVER (
                PARTITION BY
                    MEMBER_CODE
                ORDER BY
                    CHECKUP_DATE DESC
            ) AS runk
        FROM
            HEALTH_CHECKUP
    ),
    recent_checkups AS (
        SELECT
            c1.MEMBER_CODE AS MEMBER_CODE,
            c1.CHECKUP_DATE AS CHECKUP_DATE,
            c1.WEIGHT AS CURRENT_WEIGHT,
            c2.WEIGHT AS PREVIOUS_WEIGHT
        FROM
            latest AS c1
            INNER JOIN latest AS c2 ON c1.MEMBER_CODE = c2.MEMBER_CODE
            AND c1.runk = 1
            AND c2.runk = 2
    )
SELECT
    rc.CHECKUP_DATE AS CK_DATE,
    rc.MEMBER_CODE AS CODE,
    m.LAST_NAME || m.FIRST_NAME AS NAME,
    ROUND(rc.CURRENT_WEIGHT - rc.PREVIOUS_WEIGHT, 1) AS CHG_WT
FROM
    recent_checkups AS rc
    INNER JOIN MEMBER_MST AS m ON m.MEMBER_CODE = rc.MEMBER_CODE
WHERE
    ABS(CURRENT_WEIGHT - PREVIOUS_WEIGHT) >= 4.99
ORDER BY
    CHG_WT DESC,
    CODE DESC;