with recent2 as (
    select
        member_code
        ,checkup_date as cd
        ,weight
        ,rank()over(partition by member_code order by checkup_date desc) as r
    from health_checkup
)
select
    r2.cd as CK_DATE
    ,r2.member_code as CODE
    ,last_name||first_name as NAME
    ,round(r2.weight-r2old.weight,1) as CHG_WT
from recent2 as r2
inner join recent2 as r2old
on r2.member_code = r2old.member_code
and r2.r=1
and r2old.r=2
inner join member_mst as mm
on r2.member_code= mm.member_code
where abs(round(r2.weight-r2old.weight,1))>=5
order by CHG_WT desc,CODE desc