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
      MEMBER_CODE,
      CHECKUP_DATE
  )
select
  hc1.CHECKUP_DATE as CK_DATE,
  ms.MEMBER_CODE as CODE,
  ms.LAST_NAME || ms.FIRST_NAME as NAME,
  round(hc1.WEIGHT - hc2.WEIGHT, 1) 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
  CHG_WT >= 5
  or CHG_WT <= -5
order by
  CHG_WT desc,
  CODE desc;