WITH DATA AS (
    SELECT
        ROW_NUMBER() OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS NO,
        *
    FROM
        HEALTH_CHECKUP
), CURRENT AS (
    SELECT * FROM DATA WHERE NO = 1
), PREVIOUS AS (
    SELECT * FROM DATA WHERE NO = 2
)
SELECT
    CURRENT.CHECKUP_DATE AS CK_DATE,
    CURRENT.MEMBER_CODE AS CODE,
    MEMBER_MST.LAST_NAME || MEMBER_MST.FIRST_NAME AS NAME,
    ROUND(CURRENT.WEIGHT - PREVIOUS.WEIGHT, 1) AS CHG_WT
FROM
    CURRENT
INNER JOIN
    PREVIOUS ON
    PREVIOUS.MEMBER_CODE = CURRENT.MEMBER_CODE
INNER JOIN
    MEMBER_MST ON
    MEMBER_MST.MEMBER_CODE = CURRENT.MEMBER_CODE
WHERE
    ABS(ROUND(CURRENT.WEIGHT - PREVIOUS.WEIGHT, 1)) >= 5
ORDER BY
    ROUND(CURRENT.WEIGHT - PREVIOUS.WEIGHT, 1) DESC,
    CURRENT.MEMBER_CODE DESC