with T as(
select
    row_number() over(partition by HC.member_code order by HC.checkup_date desc) ROW_NO,
    HC.checkup_date,
    HC.member_code,
    MM.last_name||MM.first_name name,
    HC.weight
from
    health_checkup HC
    left join member_mst MM on HC.member_code = MM.member_code
)
select
    T1.checkup_date CK_DATE,
    T1.member_code CODE,
    T1.name NAME,
    round(T1.weight - T2.weight, 1) CHG_WT
from
    (select * from T where row_no = 1) T1
    left join (select * from T where row_no = 2) T2 on T1.member_code = T2.member_code
where
    abs(CHG_WT) >= 5
order by
    CHG_WT desc,
    T1.member_code desc