SELECT MAX(H.CHECKUP_DATE) AS CK_DATE, H.MEMBER_CODE AS CODE, LAST_NAME || FIRST_NAME AS NAME,  ROUND(H.WEIGHT - H2.WEIGHT, 1) AS CHG_WT
FROM HEALTH_CHECKUP H JOIN MEMBER_MST USING (MEMBER_CODE)
JOIN (SELECT MAX(CHECKUP_DATE) AS CK_DATE, MEMBER_CODE, WEIGHT FROM HEALTH_CHECKUP H2 WHERE CHECKUP_DATE <> (SELECT MAX(CHECKUP_DATE) FROM HEALTH_CHECKUP H3 WHERE H2.MEMBER_CODE = H3.MEMBER_CODE) GROUP BY 2) H2 USING (MEMBER_CODE)
GROUP BY 2
HAVING ABS(ROUND(H.WEIGHT - H2.WEIGHT, 1)) >= 5.0
ORDER BY 4 DESC, 2 DESC;