with sub1 as (
select
    hc1.checkup_date
    , hc1.member_code
    , hc1.weight
    , lag(hc1.weight,1) over(partition by hc1.member_code order by hc1.checkup_date) as before_wt
from health_checkup as hc1
)
select
    sub1.checkup_date as CK_DATE
    , sub1.member_code as CODE
    , last_name||first_name as NAME
    , (sub1.weight * 10 - sub1.before_wt * 10)/10 as CHG_WT
from sub1
inner join member_mst as mm on mm.member_code=sub1.member_code
where
    sub1.checkup_date in (select max(checkup_date) from health_checkup where member_code=sub1.member_code)
    and abs((sub1.weight*10 - sub1.before_wt*10)/10)>=5
order by chg_wt desc, code desc;