WITH 
HEALTH_CHECKUP_NO AS
(
SELECT
ROW_NUMBER() OVER(PARTITION BY T1.MEMBER_CODE ORDER BY T1.CHECKUP_DATE DESC) AS No,
T1.*
FROM HEALTH_CHECKUP T1
),
HEALTH_CHECKUP_NEW AS(
SELECT *
FROM HEALTH_CHECKUP_NO T1
WHERE
T1.No = 1
),
HEALTH_CHECKUP_OLD AS(
SELECT *
FROM HEALTH_CHECKUP_NO T1
WHERE
T1.No = 2
)
SELECT
T1.CHECKUP_DATE CK_DATE,
T1.MEMBER_CODE CODE,
T3.LAST_NAME || T3.FIRST_NAME NAME,
ROUND(ABS(T1.WEIGHT - T2.WEIGHT)) CHG_WT
FROM HEALTH_CHECKUP_NEW T1
LEFT OUTER JOIN HEALTH_CHECKUP_OLD T2
ON T2.MEMBER_CODE = T1.MEMBER_CODE
LEFT OUTER JOIN MEMBER_MST T3
ON T3.MEMBER_CODE = T1.MEMBER_CODE
WHERE
T1.WEIGHT - T2.WEIGHT >= 5
OR T2.WEIGHT - T1.WEIGHT >= 5
ORDER BY ROUND(ABS(T1.WEIGHT - T2.WEIGHT)) DESC,T1.MEMBER_CODE DESC