SELECT
A.CK_DATE AS CK_DATE,
A.CODE AS CODE,
C.LAST_NAME || C.FIRST_NAME AS NAME,
FORMAT("%.1f", A.WEIGHT1 - B.WEIGHT2) AS CHG_WT
FROM
(SELECT
MEMBER_CODE AS CODE,
MAX(CHECKUP_DATE) AS CK_DATE,
MAX(WEIGHT) AS WEIGHT1
FROM
HEALTH_CHECKUP
GROUP BY MEMBER_CODE) AS A
INNER JOIN
(SELECT
CODE,
DATE,
WEIGHT2
FROM
(SELECT
MEMBER_CODE AS CODE,
CHECKUP_DATE AS DATE,
WEIGHT AS WEIGHT2,
ROW_NUMBER() OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS ROW
FROM
HEALTH_CHECKUP)
WHERE ROW = 2) AS B
ON A.CODE = B.CODE
INNER JOIN
MEMBER_MST AS C
ON A.CODE = C.MEMBER_CODE
WHERE A.WEIGHT1 - B.WEIGHT2 >= 5 OR A.WEIGHT1 - B.WEIGHT2 <= -5
ORDER BY
A.WEIGHT1 - B.WEIGHT2 DESC,
A.CODE DESC;