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,
cast (100 * 
case
    when rank = 2 then -WEIGHT
    else WEIGHT
end as integer) as WEIGHT
from tgt
where rank in (1, 2)
)
select max(CK_DATE) as CK_DATE,
CODE,
NAME,
cast(SUM(WEIGHT)/100.0 as real) as CHG_WT
from temp
group by
CODE,
NAME
having abs(round(SUM(WEIGHT)/100, 1)) >=5
order by CHG_WT desc,
CODE desc