WITH T1 AS (
SELECT
	H.*
,	ROW_NUMBER() OVER(PARTITION BY M.MEMBER_CODE ORDER BY H.CHECKUP_DATE DESC) AS RANK
,   M.*
FROM
	MEMBER_MST AS M
		INNER JOIN HEALTH_CHECKUP AS H
			ON H.MEMBER_CODE = M.MEMBER_CODE
ORDER BY
    H.MEMBER_CODE ASC
,   H.CHECKUP_DATE DESC
)
SELECT
    T2.CHECKUP_DATE AS CK_DATE
,	T2.MEMBER_CODE  AS CODE
,	T2.LAST_NAME || T2.FIRST_NAME   AS NAME
,	ROUND(T2.WEIGHT - T1.WEIGHT, 1) AS CHG_WT
FROM
	T1
		INNER JOIN T1 AS T2
			ON	T2.MEMBER_CODE  = T1.MEMBER_CODE
			AND	T2.CHECKUP_DATE > T1.CHECKUP_DATE
WHERE
	T1.RANK IN (1, 2)
AND abs(round(T2.WEIGHT - T1.WEIGHT, 1)) >= 5
ORDER BY
	4 DESC
,   1 ASC
;