WITH codebasedata AS (
	SELECT
		MEMBER_CODE
		,CHECKUP_DATE
		,WEIGHT
		,RANK() OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS chknum
	FROM HEALTH_CHECKUP
)
,yokomotidata AS (
	SELECT
		t0.MEMBER_CODE
		,t0.CHECKUP_DATE
		,t0.WEIGHT AS WEIGHT01
		,t1.WEIGHT AS WEIGHT02
	FROM codebasedata AS t0
	INNER JOIN codebasedata AS t1
		ON t0.MEMBER_CODE = t1.MEMBER_CODE
			AND t1.chknum = 2
	WHERE t0.chknum = 1
)
SELECT
	t0.CHECKUP_DATE AS CK_DATE
	,t0.MEMBER_CODE AS CODE
	,t1.LAST_NAME || t1.FIRST_NAME AS NAME
	,ROUND((t0.WEIGHT01 - t0.WEIGHT02),1) AS CHG_WT
FROM yokomotidata AS t0
INNER JOIN MEMBER_MST AS t1
	ON t0.MEMBER_CODE = t1.MEMBER_CODE
WHERE ABS(ROUND((t0.WEIGHT01 - t0.WEIGHT02),1)) >= 5
ORDER BY CHG_WT DESC,t0.MEMBER_CODE DESC