WITH TMP(CK_DATE, CODE, NAME, CHG_WT_TMP) AS (
    SELECT
        MAX(H1.CHECKUP_DATE),
        H1.MEMBER_CODE,
        M.LAST_NAME || M.FIRST_NAME,
        H2.CHG_WT_TMP
    FROM HEALTH_CHECKUP AS H1
    LEFT JOIN MEMBER_MST AS M ON H1.MEMBER_CODE=M.MEMBER_CODE
    NATURAL INNER JOIN
        (SELECT
            CHECKUP_DATE,
            MEMBER_CODE,
            CAST(WEIGHT*10 AS INTEGER) - MIN(CAST(WEIGHT*10 AS INTEGER)) 
                                            OVER(PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE ASC ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS CHG_WT_TMP
        FROM HEALTH_CHECKUP) AS H2
    GROUP BY H1.MEMBER_CODE
)
SELECT 
   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;