SELECT
  CK_DATE
  ,CODE
  ,LAST_NAME || FIRST_NAME AS NAME
  ,ROUND(WEIGHT - WEIGHT_1,1) AS CHG_WT
FROM(
  SELECT
       CHECKUP_DATE AS CK_DATE
       ,MEMBER_CODE AS CODE
       ,row_number() over (partition by MEMBER_CODE order by CHECKUP_DATE DESC) AS COUNT
       ,WEIGHT
       ,LEAD (WEIGHT, 1) OVER (partition by MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS WEIGHT_1 
  FROM HEALTH_CHECKUP
) HC
INNER JOIN MEMBER_MST MM ON MM.MEMBER_CODE = HC.CODE
WHERE COUNT = 1
  AND ABS(ROUND(WEIGHT_1 - WEIGHT,1)) >= 5
ORDER BY WEIGHT_1 - WEIGHT , CODE DESC