WITH HEALTH_CHECKUP_BEFORE AS(
    SELECT h1.MEMBER_CODE ,h1.WEIGHT FROM HEALTH_CHECKUP h1
    INNER JOIN (SELECT MEMBER_CODE,MAX(CHECKUP_DATE) FROM HEALTH_CHECKUP m1 GROUP BY MEMBER_CODE)
    ON HEALTH_CHECKUP.MEMBER_CODE = m1.MEMBER_CODE
    WHERE CHECKUP_DATE < m.CHECKUP_DATE
    ),
HEALTH_CHECKUP_AFTER AS(
    SELECT h2.CHECKUP_DATE,h2.MEMBER_CODE ,h2.WEIGHT FROM HEALTH_CHECKUP h2
    INNER JOIN (SELECT MEMBER_CODE,MAX(CHECKUP_DATE) FROM HEALTH_CHECKUP m2 GROUP BY MEMBER_CODE)
    ON HEALTH_CHECKUP.MEMBER_CODE = m2.MEMBER_CODE
    WHERE CHECKUP_DATE = m.CHECKUP_DATE
    )
SELECT
    a.CHECKUP_DATE AS CK_DATE
    ,a.MEMBER_CODE AS CODE
    ,m.LAST_NAME || m.FIRST_NAME AS NAME
    ,a.WEIGHT - b.WEIGHT AS CHG_WT
FROM
    HEALTH_CHECKUP_AFTER a
    INNER JOIN MEMBER_MST m ON a.MEMBER_CODE = m.MEMBER_CODE
    INNER JOIN HEALTH_CHECKUP_BEFORE b ON a.MEMBER_CODE = b.MEMBER_CODE
GROUP BY
    a.MEMBER_CODE 
HAVING
    a.WEIGHT - b.WEIGHT > 5
    AND a.WEIGHT - b.WEIGHT < -5
ORDER BY
    CHG_WT DESC ,CODE DESC