WITH LEAD AS(
    SELECT
        CHECKUP_DATE
        , LEAD(CHECKUP_DATE) OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS LEAD_CHECKUP_DATE
        , MEMBER_CODE
        , WEIGHT
        , LEAD(WEIGHT) OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS LEAD_WEIGHT
    FROM
        HEALTH_CHECKUP
)
SELECT
    FIRST_VALUE(CHECKUP_DATE) OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS CK_DATE
    , MEMBER_CODE AS CODE
    , LAST_NAME||FIRST_NAME AS NAME
    , ROUND(WEIGHT - LEAD_WEIGHT,1) AS CHG_WT
FROM
    LEAD
    INNER JOIN MEMBER_MST USING(MEMBER_CODE)
WHERE
    ABS(ROUND(WEIGHT - LEAD_WEIGHT,1)) >= 5
    AND LEAD_CHECKUP_DATE IS NOT NULL
ORDER BY 4 DESC, 2 DESC;