SELECT
    HC01.CHECKUP_DATE AS CK_DATE
    , HC01.MEMBER_CODE AS CODE
    , MM.LAST_NAME || MM.FIRST_NAME AS NAME
    , ROUND(HC01.WEIGHT - HC02.WEIGHT,1) AS CHG_WT
FROM
    (SELECT
        CHECKUP_DATE
        , MEMBER_CODE
        , MAX(CHECKUP_DATE)
            OVER (PARTITION BY MEMBER_CODE ORDER BY MEMBER_CODE ASC, CHECKUP_DATE DESC
                ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING) AS LATER_DATE
        , MAX(CHECKUP_DATE)
            OVER(PARTITION BY MEMBER_CODE ORDER BY MEMBER_CODE ASC, CHECKUP_DATE DESC) AS LATEST_DATE
        , WEIGHT
    FROM
        HEALTH_CHECKUP) HC01
    INNER JOIN HEALTH_CHECKUP HC02
        ON HC02.CHECKUP_DATE = HC01.LATER_DATE AND
        HC02.MEMBER_CODE = HC02.MEMBER_CODE
    INNER JOIN MEMBER_MST AS MM
        ON MM.MEMBER_CODE = HC01.MEMBER_CODE
WHERE
    HC01.CHECKUP_DATE = HC01.LATEST_DATE AND
    (ROUND(HC01.WEIGHT - HC02.WEIGHT, 1) >= 5.0 OR
    ROUND(HC01.WEIGHT - HC02.WEIGHT, 1) <= -5.0)
ORDER BY
    CHG_WT DESC
    , HC01.MEMBER_CODE DESC;