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 >=5 or -5 <= CHG_WT
order by CHG_WT desc,MEMBER_CODE desc