with
target as (
  select distinct
      MEMBER_CODE 
    , nth_value(CHECKUP_DATE, 1) over(partition by MEMBER_CODE order by CHECKUP_DATE desc) as   LATEST_CHECKUP_DATE
    , nth_value(CHECKUP_DATE, 2) over(partition by MEMBER_CODE order by CHECKUP_DATE desc) as PREVIOUS_CHECKUP_DATE
    , (  10 * nth_value(WEIGHT,       1) over(partition by MEMBER_CODE order by CHECKUP_DATE desc) 
       - 10 * nth_value(WEIGHT,       2) over(partition by MEMBER_CODE order by CHECKUP_DATE desc)
      ) / 10 as CHG_WT
  from
    HEALTH_CHECKUP
)
select
    LATEST_CHECKUP_DATE     as CK_DATE
  , MEMBER_CODE             as CODE
  , LAST_NAME || FIRST_NAME as NAME
  , CHG_WT                  as CHG_WT
from
  target t
  inner join MEMBER_MST m using(MEMBER_CODE )
where
   CHG_WT >= 5
or CHG_WT <= -5
order by
    CHG_WT desc
  , CODE   desc
;