WITH TMP AS(
select 
CHECKUP_DATE,
WEIGHT*10 - 10*lag(WEIGHT) over (partition by MEMBER_CODE order by CHECKUP_DATE)  r
,MEMBER_CODE 
from
HEALTH_CHECKUP
)
SELECT CHECKUP_DATE CK_DATE, TMP.MEMBER_CODE CODE,LAST_NAME||FIRST_NAME NAME,
r/10 CHG_WT FROM TMP
left join MEMBER_MST on TMP.member_code = member_MST.member_code 
where r>=50 or r<=-50
order by CHG_WT desc,TMP.MEMBER_CODE desc