SELECT
 CHG.DATE2 AS CK_DATE,
 MST.MEMBER_CODE AS CODE,
 MST.LAST_NAME || MST.FIRST_NAME AS NAME,
 CHG.CHG_WT AS CHG_WT
FROM MEMBER_MST AS MST
LEFT JOIN (
SELECT 
TB1.CHECKUP_DATE DATE1
, TB2.CHECKUP_DATE DATE2
, TB1.MEMBER_CODE
, ROUND(TB2.WEIGHT - TB1.WEIGHT, 1) AS CHG_WT
FROM HEALTH_CHECKUP AS TB1
LEFT JOIN HEALTH_CHECKUP AS TB2
ON TB1.MEMBER_CODE = TB2.MEMBER_CODE 
AND TB1.CHECKUP_DATE < TB2.CHECKUP_DATE
WHERE DATE2 IS NOT NULL
) CHG
ON MST.MEMBER_CODE = CHG.MEMBER_CODE
WHERE CHG.CHG_WT >= 5 OR CHG.CHG_WT <= -5
ORDER BY CHG.CHG_WT desc, MST.MEMBER_CODE desc