with tmp as (
    select
        h.checkup_date as CK_DATE
        , h.member_code as CODE
        , m.last_name || m.first_name as NAME
        , round(h.weight - lead(h.weight, 1) over(
            partition by h.member_code
            order by h.checkup_date desc
        ), 1) as CHG_WT
    from 
        health_checkup as h
    left join
        member_mst as m
    on
        h.member_code = m.member_code
)

select
    max(CK_DATE) as CK_DATE
    , CODE
    , NAME
    , CHG_WT
from
    tmp
where
    CHG_WT >= 5
    or CHG_WT <= -5
group by
    CODE
order by
    CHG_WT desc
    , CODE desc
;