with tmp1 AS(
    select
        MEMBER_CODE
        , CHECKUP_DATE
        , WEIGHT
        , row_number() over (partition by MEMBER_CODE order by CHECKUP_DATE desc) as r_num
    from HEALTH_CHECKUP
)
select
    t1.CHECKUP_DATE AS CK_DATE
    , t1.MEMBER_CODE as CODE
    , t3.LAST_NAME || t3.FIRST_NAME AS NAME
    , ROUND(t1.WEIGHT - t2.WEIGHT,2) as CHG_WT
from tmp1 t1
inner join tmp1 t2
    on t1.MEMBER_CODE = t2.MEMBER_CODE
    and t2.r_num = 2
inner join MEMBER_MST t3
    on t1.MEMBER_CODE = t3.MEMBER_CODE
where t1.r_num = 1
and abs(ROUND(t1.WEIGHT - t2.WEIGHT,2)) >5
order by ROUND(t1.WEIGHT - t2.WEIGHT,2) desc, t1.MEMBER_CODE desc