select one.CHECKUP_DATE as CK_DATE,
one.MEMBER_CODE as CODE,
m.LAST_NAME || m.FIRST_NAME as NAME,
round(one.WEIGHT - two.WEIGHT, 1) as CHG_WT
from (select RANK() OVER (PARTITION BY MEMBER_CODE 	ORDER BY CHECKUP_DATE desc) as rank,
CHECKUP_DATE,
MEMBER_CODE,
WEIGHT
from HEALTH_CHECKUP
) one
inner join (select RANK() OVER (PARTITION BY MEMBER_CODE 	ORDER BY CHECKUP_DATE desc) as rank,
CHECKUP_DATE,
MEMBER_CODE,
WEIGHT
from HEALTH_CHECKUP
) two
on one.MEMBER_CODE = two.MEMBER_CODE
inner join MEMBER_MST m
on one.MEMBER_CODE = m.MEMBER_CODE
where (round(one.WEIGHT - two.WEIGHT, 1) >= 5
or round(one.WEIGHT - two.WEIGHT, 1) <= -5)
and one.rank = 1
and two.rank = 2
order by 
CHG_WT desc,
CODE desc