with cte as (select
MEMBER_CODE,WEIGHT
,rank() over (partition by MEMBER_CODE order by CHECKUP_DATE desc) as R
,max(CHECKUP_DATE) over (partition by MEMBER_CODE) as CK_DATE
from
HEALTH_CHECKUP
)
,cte2 as (select
    a.MEMBER_CODE as CODE
    ,a.CK_DATE as CK_DATE
    ,round(1.0 * a.WEIGHT - 1.0*b.WEIGHT,1) as CHG_WT
from
    cte as a
    inner join
    cte as b
    on a.MEMBER_CODE=b.MEMBER_CODE and a.R =1 and b.R=2
where
    5<=CHG_WT or CHG_WT<=-5
    )
select
b.CK_DATE
,b.CODE
,a.LAST_NAME||a.FIRST_NAME as NAME
,b.CHG_WT
from
    MEMBER_MST as a
    inner join
    cte2 as b
    on a.MEMBER_CODE=b.CODE
order by
b.CHG_WT desc
, b.CODE desc