with tmp1 as(
select MEMBER_CODE,WEIGHT,CHECKUP_DATE,
WEIGHT-
Lead(WEIGHT)
over(partition by MEMBER_CODE order by CHECKUP_DATE desc) as CHG_WT,
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,
round(CHG_WT,2) as CHG_WT
  from tmp1 b
 where rn = 1
   and CHG_WT not between -5 and 5
order by CHG_WT desc,MEMBER_CODE desc