SELECT
HEALTH1.CHECKUP_DATE as CK_DATE
,HEALTH1.MEMBER_CODE as CODE
,MEMBER_MST.LAST_NAME||MEMBER_MST.FIRST_NAME as NAME
,ROUND((SUM(HEALTH1.WEIGHT) - SUM(HEALTH2.WEIGHT)),1) as CHG_WT
FROM
HEALTH_CHECKUP HEALTH1
LEFT JOIN
MEMBER_MST
ON
HEALTH1.MEMBER_CODE = MEMBER_MST.MEMBER_CODE
LEFT JOIN
HEALTH_CHECKUP HEALTH2
ON
HEALTH1.MEMBER_CODE = HEALTH2.MEMBER_CODE
AND
HEALTH1.CHECKUP_DATE > HEALTH2.CHECKUP_DATE
WHERE ROUND(HEALTH1.WEIGHT - HEALTH2.WEIGHT,1) >= 5 OR ROUND(HEALTH1.WEIGHT - HEALTH2.WEIGHT,1) <= -5
GROUP BY HEALTH1.CHECKUP_DATE,HEALTH1.MEMBER_CODE,MEMBER_MST.LAST_NAME,MEMBER_MST.FIRST_NAME
ORDER BY
CHG_WT DESC,HEALTH1.MEMBER_CODE DESC