SELECT
MAX(H.CHECKUP_DATE) AS CK_DATE,
M.MEMBER_CODE AS CODE,
M.LAST_NAME || M.FIRST_NAME AS NAME,
H.WEIGHT - (select H2.WEIGHT from HEALTH_CHECKUP AS H2 where  H2.MEMBER_CODE = H.MEMBER_CODE order by H2.CHECKUP_DATE  limit 2) AS CHG_WT
FROM
HEALTH_CHECKUP  AS H
LEFT JOIN
MEMBER_MST AS M ON H.MEMBER_CODE = M.MEMBER_CODE
where
CHG_WT >= 5 OR CHG_WT <= -5
GROUP BY
H.MEMBER_CODE