SELECT CHECKUP_DATE AS CK_DATE
,TEST.MEMBER_CODE AS CODE
,LAST_NAME || FIRST_NAME AS NAME
,WEIGHT AS CHG_WT
FROM(
SELECT MEMBER_CODE
       ,ROUND(SUM(CASE WHEN ROWNUM = 1 THEN WEIGHT ELSE WEIGHT * -1 END),1) AS WEIGHT
       ,MAX(CHECKUP_DATE) AS CHECKUP_DATE
FROM(      
SELECT MEMBER_CODE,CHECKUP_DATE,WEIGHT,ROW_NUMBER() OVER(PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS ROWNUM
		FROM HEALTH_CHECKUP
		)
WHERE ROWNUM <= 2
GROUP BY MEMBER_CODE
) TEST
LEFT JOIN MEMBER_MST
ON MEMBER_MST.MEMBER_CODE = TEST.MEMBER_CODE
WHERE CHG_WT >= 5 OR CHG_WT <= -5
ORDER BY WEIGHT DESC,TEST.MEMBER_CODE DESC