SELECT HC1.CHECKUP_DATE AS CK_DATE, HC1.MEMBER_CODE AS CODE, MM.LAST_NAME || MM.FIRST_NAME AS NAME,ROUND(HC1.WEIGHT - HC2.WEIGHT,1) AS CHG_WT
FROM HEALTH_CHECKUP HC1,HEALTH_CHECKUP HC2
LEFT JOIN MEMBER_MST MM
ON HC1.MEMBER_CODE = MM.MEMBER_CODE
WHERE 
HC1.MEMBER_CODE = HC2.MEMBER_CODE
AND HC1.CHECKUP_DATE > HC2.CHECKUP_DATE
AND (HC1.WEIGHT - HC2.WEIGHT  >= 5.0
OR HC1.WEIGHT - HC2.WEIGHT  <= -5.0)
ORDER BY CHG_WT desc,CODE desc