SELECT
  CK_DATE
  ,CODE
  ,LAST_NAME || FIRST_NAME AS NAME
  ,(WEIGHT*10 - WEIGHT_1*10)/10 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((WEIGHT*10 - WEIGHT_1*10)/10) >= 5
  AND WEIGHT_1 IS NOT NULL
ORDER BY CHG_WT DESC
       , CODE DESC