with tmp1 as(
select MEMBER_CODE,WEIGHT,CHECKUP_DATE,
Lead(WEIGHT)
over(partition by MEMBER_CODE order by CHECKUP_DATE desc) as Lead_WEIGHT,
Row_Number()
over(partition by MEMBER_CODE order by CHECKUP_DATE desc) as rn
  from HEALTH_CHECKUP)
select CHECKUP_DATE as CK_DATE,
MEMBER_CODE,
(select c.LAST_NAME || c.FIRST_NAME
   from MEMBER_MST c
  where c.MEMBER_CODE = b.MEMBER_CODE) as  NAME,
WEIGHT-Lead_WEIGHT as CHG_WT
  from tmp1 b
 where rn = 1
   and WEIGHT - Lead_WEIGHT between -5 and 5
order by CHG_WT desc,MEMBER_CODE desc