WITH LAST2 AS (
    SELECT
        HC_L.CHECKUP_DATE AS CK_DATE,
        HC_L.MEMBER_CODE,
        HC_L.WEIGHT AS AFT_WT,
        HC_R.WEIGHT AS BEF_WT
    FROM
        HEALTH_CHECKUP AS HC_L
        INNER JOIN HEALTH_CHECKUP AS HC_R
            ON HC_L.MEMBER_CODE = HC_R.MEMBER_CODE
            AND HC_L.CHECKUP_DATE > HC_R.CHECKUP_DATE
    GROUP BY
        HC_L.MEMBER_CODE
    HAVING
        HC_L.CHECKUP_DATE == MAX(HC_L.CHECKUP_DATE)
        AND HC_R.CHECKUP_DATE == MAX(HC_R.CHECKUP_DATE)
)

SELECT
    LAST2.CK_DATE,
    MEMBER_CODE AS CODE,
    MEMBER_MST.LAST_NAME || MEMBER_MST.FIRST_NAME AS NAME,
    ROUND(AFT_WT - BEF_WT, 2) AS CHG_WT
FROM
    LAST2
    INNER JOIN MEMBER_MST
        USING (MEMBER_CODE)
WHERE
    ABS(CHG_WT) >= 5
ORDER BY
    CHG_WT DESC,
    MEMBER_CODE DESC