WITH TMP(CK_DATE, CODE, NAME, CHG_WT_TMP) AS (
    SELECT 
        H.CHECKUP_DATE,
        H.MEMBER_CODE,
        M.LAST_NAME || M.FIRST_NAME,
        CAST(H.WEIGHT*10 AS INTEGER) - MIN(CAST(H.WEIGHT*10 AS INTEGER)) 
                                            OVER(PARTITION BY H.MEMBER_CODE ORDER BY H.CHECKUP_DATE ASC ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING)
    FROM HEALTH_CHECKUP AS H
    LEFT JOIN MEMBER_MST AS M 
        ON H.MEMBER_CODE=M.MEMBER_CODE
)

SELECT 
   MAX(CK_DATE) AS CK_DATE,
   CODE,
   NAME,
   CAST(CHG_WT_TMP AS REAL)/10 AS CHG_WT
FROM TMP
WHERE ABS(CHG_WT)>=5
GROUP BY CODE
ORDER BY CHG_WT DESC, CODE DESC;