SELECT
    HC2.CHECKUP_DATE AS CK_DATE,
    HC2.MEMBER_CODE AS CODE,
    (M.LAST_NAME || M.FIRST_NAME) AS NAME,
    CASE
        WHEN ROUND(HC2.WEIGHT - HC1.WEIGHT, 1) = CAST(ROUND(HC2.WEIGHT - HC1.WEIGHT, 1) AS INTEGER)
        THEN CAST(ROUND(HC2.WEIGHT - HC1.WEIGHT, 1) AS INTEGER)
        ELSE ROUND(HC2.WEIGHT - HC1.WEIGHT, 1)
    END AS CHG_WT
FROM
    HEALTH_CHECKUP HC1
JOIN
    HEALTH_CHECKUP HC2 ON HC1.MEMBER_CODE = HC2.MEMBER_CODE AND HC1.CHECKUP_DATE < HC2.CHECKUP_DATE
JOIN
    MEMBER_MST M ON HC2.MEMBER_CODE = M.MEMBER_CODE
WHERE
    HC2.CHECKUP_DATE = (
        SELECT
            MAX(HC3.CHECKUP_DATE)
        FROM
            HEALTH_CHECKUP HC3
        WHERE
            HC3.MEMBER_CODE = HC2.MEMBER_CODE)
    AND HC1.CHECKUP_DATE = (
        SELECT
            MAX(HC4.CHECKUP_DATE)
        FROM
            HEALTH_CHECKUP HC4
        WHERE
            HC4.MEMBER_CODE = HC1.MEMBER_CODE AND HC4.CHECKUP_DATE < HC2.CHECKUP_DATE)
    AND ABS((HC2.WEIGHT * 10) - (HC1.WEIGHT * 10)) >= 50
ORDER BY
    CHG_WT DESC,
    CODE DESC;