SELECT
 CK_DATE,
 CODE,
 LAST_NAME || FIRST_NAME AS NAME,
 CHG_WT
FROM
(
 SELECT
  MAXDATE AS CK_DATE,
  A.MEMBER_CODE AS CODE,
  A.WEIGHT AS AFTERWEIGHT,
  D.BEFOREWEIGHT,
  ROUND(A.WEIGHT - D.BEFOREWEIGHT, 1) AS CHG_WT
 FROM
 (
  SELECT
   MAX(CHECKUP_DATE) AS MAXDATE,
   MEMBER_CODE,
   WEIGHT
  FROM
   HEALTH_CHECKUP
  GROUP BY
   MEMBER_CODE
 ) A
 INNER JOIN
 (
  SELECT
   CHECKUP_DATE AS SECONDDATE,
   MEMBER_CODE,
   WEIGHT AS BEFOREWEIGHT
  FROM
   HEALTH_CHECKUP B
  WHERE NOT EXISTS
  (
   SELECT
    MAXDATE,
    MEMBER_CODE
   FROM
   (
    SELECT
     MAX(CHECKUP_DATE) AS MAXDATE,
     MEMBER_CODE
    FROM
     HEALTH_CHECKUP
    GROUP BY
     MEMBER_CODE
   ) C
  WHERE
   MAXDATE = B.CHECKUP_DATE
  AND
   MEMBER_CODE = B.MEMBER_CODE
  ) 
 ) D
 ON
  D.MEMBER_CODE = A.MEMBER_CODE
) E
INNER JOIN
 MEMBER_MST
ON
 MEMBER_MST.MEMBER_CODE = E.CODE
WHERE
 CHG_WT IS NOT NULL
AND
(
 CHG_WT >= 5
OR
 CHG_WT <= -5
)
ORDER BY
 CHG_WT DESC,
 CODE DESC