with temp as (
    select member_code,
    checkup_date,
    row_number() over (partition by member_code order by checkup_date desc) as rank,
    weight
    from health_checkup
)

select temp.checkup_date as CK_DATE,
MEMBER_MST.MEMBER_CODE as CODE,
MEMBER_MST.LAST_NAME || '' || MEMBER_MST.FIRST_NAME as NAME,
round(temp.weight - temp2.weight, 1) as CHG_WT
from temp
inner join temp as temp2 
on temp.member_code = temp2.member_code
and temp.rank = 1
and temp2.rank = 2
inner join MEMBER_MST
on MEMBER_MST.MEMBER_CODE = temp.member_code
where abs(CHG_WT) >= 5
order by CHG_WT desc, MEMBER_MST.MEMBER_CODE desc;