with tgt as (select
CHECKUP_DATE as CK_DATE,
MEMBER_CODE as CODE,
LAST_NAME || FIRST_NAME as NAME,
WEIGHT as WEIGHT,
row_number() over (partition by MEMBER_CODE order by CHECKUP_DATE desc) as rank
from
HEALTH_CHECKUP
left join MEMBER_MST using(MEMBER_CODE)
)

,temp as (select
CK_DATE
,CODE
,NAME,
100 * 
case
    when rank = 2 then -WEIGHT
    else WEIGHT
end as WEIGHT
from tgt
where rank in (1, 2)
)


select max(CK_DATE) as CK_DATE,
CODE,
NAME,
round(SUM(WEIGHT)/100, 1) as CHG_WT
from temp
group by
CODE,
NAME

having abs(round(SUM(WEIGHT)/100, 1)) >=5

order by CHG_WT desc,
CODE desc