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