with tmp as(
select *,
row_number() over(partition by MEMBER_CODE order by CHECKUP_DATE desc) as hdate
from HEALTH_CHECKUP
),
w_change as(
select t1.MEMBER_CODE as CODE,
10*t1.WEIGHT-10*t2.WEIGHT as wch,
t1.CHECKUP_DATE as CK_DATE
from tmp t1 inner join tmp t2 on (t1.MEMBER_CODE = t2.MEMBER_CODE and t1.hdate+1=t2.hdate)
)
select 
CK_DATE,
CODE,
LAST_NAME||FIRST_NAME as NAME,
wch/10 as CHG_WT
from w_change left join MEMBER_MST on CODE = MEMBER_CODE
where wch >= 50 or wch <= -50
order by 4 desc, 2 desc