with
  hc as (
    select
      MEMBER_CODE,
      WEIGHT,
      CHECKUP_DATE,
      ROW_NUMBER() OVER (
        PARTITION BY
          MEMBER_CODE
        ORDER BY
          CHECKUP_DATE DESC
      ) AS rn
    from
      HEALTH_CHECKUP
    order by
      CHECKUP_DATE
  )
select
  hc1.CHECKUP_DATE as CK_DATE,
  ms.MEMBER_CODE as CODE,
  round(hc1.WEIGHT - hc2.WEIGHT, 2) as CHG_WT
from
  MEMBER_MST ms
  left outer join hc hc2 on ms.MEMBER_CODE = hc2.MEMBER_CODE
  and hc2.rn = 2
  left outer join hc hc1 on ms.MEMBER_CODE = hc1.MEMBER_CODE
  and hc1.rn = 1
where
  ABS(CHG_WT) >= 5.0
order by
  CHG_WT desc,
  CODE;