WITH MAX_DATE AS(
SELECT MEMBER_CODE, MAX(CHECKUP_DATE) AS CHECKUP_DATE FROM HEALTH_CHECKUP GROUP BY MEMBER_CODE
)
SELECT
	H1.CHECKUP_DATE AS CK_DATE
	,H1.MEMBER_CODE AS CODE
	,ROUND(CAST(H1.WEIGHT AS NUMERIC) - CAST(H2.WEIGHT AS NUMERIC), 1) AS CHG_WT
FROM
	(SELECT * FROM HEALTH_CHECKUP H
		INNER JOIN MAX_DATE
			ON H.MEMBER_CODE = MAX_DATE.MEMBER_CODE
			AND H.CHECKUP_DATE = MAX_DATE.CHECKUP_DATE
	) H1
	INNER JOIN (SELECT * FROM HEALTH_CHECKUP H
					INNER JOIN (SELECT H.MEMBER_CODE, MAX(H.CHECKUP_DATE) AS CHECKUP_DATE FROM HEALTH_CHECKUP H
								LEFT OUTER JOIN MAX_DATE ON H.MEMBER_CODE = MAX_DATE.MEMBER_CODE AND H.CHECKUP_DATE = MAX_DATE.CHECKUP_DATE
								WHERE MAX_DATE.CHECKUP_DATE IS NULL
								GROUP BY H.MEMBER_CODE) SUB
						ON H.MEMBER_CODE = SUB.MEMBER_CODE
						AND H.CHECKUP_DATE = SUB.CHECKUP_DATE
				) H2
		ON H1.MEMBER_CODE = H2.MEMBER_CODE
	INNER JOIN MEMBER_MST M
		ON H1.MEMBER_CODE = M.MEMBER_CODE
WHERE
	ABS(ROUND(CAST(H1.WEIGHT AS NUMERIC) - CAST(H2.WEIGHT AS NUMERIC), 1)) >= 5
ORDER BY
	CHG_WT DESC
	,CODE DESC
;