select  w1.dt CK_DATE
        ,m.MEMBER_CODE CODE
        ,m.LAST_NAME || m.FIRST_NAME NAME
        ,replace(CAST(( CAST(10*c1.WEIGHT AS INTEGER) - CAST(10*c2.WEIGHT AS INTEGER)) AS INTEGER)/10,'.0','') CHG_WT
--        ,CAST(c1.WEIGHT AS NUMERIC)
 --       ,CAST(c2.WEIGHT AS NUMERIC)
  from  (select  MEMBER_CODE,MAX(CHECKUP_DATE) dt
      from  HEALTH_CHECKUP h1
     group by MEMBER_CODE
    )w1,
    (select  MEMBER_CODE,MAX(CHECKUP_DATE) dt
      from  (
        select  MEMBER_CODE,CHECKUP_DATE
          from  HEALTH_CHECKUP h
        except
        select  MEMBER_CODE,MAX(CHECKUP_DATE) 
          from  HEALTH_CHECKUP h1
         group by MEMBER_CODE
    )
     group by MEMBER_CODE
     )w2,HEALTH_CHECKUP c1,HEALTH_CHECKUP c2,MEMBER_MST m
     
 where  w1.MEMBER_CODE = w2.MEMBER_CODE
   and  w1.MEMBER_CODE = c1.MEMBER_CODE
   and  w2.MEMBER_CODE = c2.MEMBER_CODE
   and  w1.dt = c1.CHECKUP_DATE
   and  w2.dt = c2.CHECKUP_DATE
   and  CAST(( CAST(10*c1.WEIGHT AS INTEGER) - CAST(10*c2.WEIGHT AS INTEGER)) AS INTEGER) >= 50
   and  w1.MEMBER_CODE = m.MEMBER_CODE
 order by 4 desc,m.MEMBER_CODE desc