WITH SUB1 AS (
 SELECT
  HC1.CHECKUP_DATE,
  HC1.MEMBER_CODE,
  HC1.WEIGHT,
  LAG(HC1.WEIGHT,1) OVER(
   PARTITION BY 
    HC1.MEMBER_CODE
   ORDER BY
    HC1.CHECKUP_DATE
  )AS BEFORE_WT
 FROM
  HEALTH_CHECKUP AS HC1
)

SELECT
 SUB1.CHECKUP_DATE AS CK_DATE,
 SUB1.MEMBER_CODE AS CODE,
 LAST_NAME || FIRST_NAME AS NAME,
 (SUB1.WEIGHT * 10 - SUB1.BEFORE_WT * 10) / 10 AS CHG_WT

FROM
 SUB1
 INNER JOIN MEMBER_MST AS MM
  ON MM.MEMBER_CODE = SUB1.MEMBER_CODE
 WHERE
  SUB1.CHECKUP_DATE = (
   SELECT
    MAX(CHECKUP_DATE)
   FROM
    HEALTH_CHECKUP
   WHERE
    MEMBER_CODE = SUB1.MEMBER_CODE
  )
  
  AND ABS((SUB1.WEIGHT * 10 - SUB1.BEFORE_WT * 10) / 10) >=5
  
ORDER BY
 CHG_WT DESC,
 CODE DESC;