SELECT
T1.CHECKUP_DATE AS CK_DATE,
T1.MEMBER_CODE AS CODE,
MM.LAST_NAME || FIRST_NAME AS NAME,
--T1.WEIGHT AS 直近体重,
--T2.WEIGHT AS 前回体重,
--ROUND(T1.WEIGHT,1) AS 直近体重,
--ROUND(T2.WEIGHT,1) AS 前回体重,
ROUND(T1.WEIGHT - T2.WEIGHT,1) AS CHG_WT
FROM
(
	SELECT
	rownum,
	CHECKUP_DATE,
	MEMBER_CODE,
	WEIGHT
	FROM
	(
		SELECT
		row_number() over(partition by MEMBER_CODE order by CHECKUP_DATE DESC) AS rownum, 
		CHECKUP_DATE
		,MEMBER_CODE
		,WEIGHT
		FROM
		HEALTH_CHECKUP
	)
	WHERE rownum = 1
) T1
LEFT JOIN
(
	SELECT
	rownum,
	CHECKUP_DATE,
	MEMBER_CODE,
	WEIGHT
	FROM
	(
		SELECT
		row_number() over(partition by MEMBER_CODE order by CHECKUP_DATE DESC) AS rownum, 
		CHECKUP_DATE
		,MEMBER_CODE
		,WEIGHT
		FROM
		HEALTH_CHECKUP
	)
	WHERE rownum = 2
) T2
ON T1.MEMBER_CODE = T2.MEMBER_CODE
LEFT JOIN MEMBER_MST MM
ON T1.MEMBER_CODE  = MM.MEMBER_CODE
WHERE ROUND(T1.WEIGHT - T2.WEIGHT,1) >= 5.0 OR ROUND(T2.WEIGHT - T1.WEIGHT,1) >= 5.0
ORDER BY CHG_WT DESC,CODE DESC;