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