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