with a as (
select MEMBER_CODE, max(CHECKUP_DATE) as md
from HEALTH_CHECKUP
group by MEMBER_CODE
), b as (

select CHECKUP_DATE,MEMBER_CODE,WEIGHT,md,
WEIGHT - LAG(WEIGHT) OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE) AS w_diff
from HEALTH_CHECKUP left join a using (MEMBER_CODE)
), c as (

select CHECKUP_DATE as CK_DATE, MEMBER_CODE as CODE, LAST_NAME || FIRST_NAME as NAME, round(w_diff,1) as CHG_WT
from b left join MEMBER_MST using (MEMBER_CODE)
where md = CHECKUP_DATE and (w_diff < -4.999 or 4.999 < w_diff)
)

select * from c
order by CHG_WT desc, CODE desc