WITH CHECKUP AS (
  SELECT 
   l.MEMBER_CODE
  ,l.CHECKUP_DATE
  ,l.WEIGHT
  ,ROW_NUMBER() OVER (PARTITION BY l.MEMBER_CODE ORDER BY l.CHECKUP_DATE DESC) AS RN
  FROM HEALTH_CHECKUP l
)
SELECT
 c1.CHECKUP_DATE AS CK_DATE
,c1.MEMBER_CODE AS CODE
,(m.LAST_NAME || ' ' || m.FIRST_NAME) AS NAME
,ROUND(c1.WEIGHT - c2.WEIGHT, 1) AS CHG_WT
FROM CHECKUP c1
JOIN CHECKUP c2
ON c1.MEMBER_CODE = c2.MEMBER_CODE
AND c2.RN = 2
JOIN MEMBER_MST m
ON c1.MEMBER_CODE = m.MEMBER_CODE
WHERE c1.RN = 1
AND ABS(ROUND(c1.WEIGHT - c2.WEIGHT, 1)) >= 5
ORDER BY CHG_WT DESC, m.MEMBER_CODE DESC
;