WITH TMP(CK_DATE, CODE, NAME, CHG_WT_TMP) AS (
    SELECT
        MAX(HC.CHECKUP_DATE),
        HC.MEMBER_CODE AS CODE,
        MM.LAST_NAME || MM.FIRST_NAME,
        HC.WEIGHT - MIN(HC.WEIGHT) OVER (ORDER BY HC.CHECKUP_DATE DESC ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS CHG_WT_TMP
    FROM HEALTH_CHECKUP AS HC, MEMBER_MST AS MM
    WHERE HC.MEMBER_CODE=MM.MEMBER_CODE
    GROUP BY CODE
)
SELECT 
    CK_DATE,
    CODE,
    NAME,
    CAST(CHG_WT_TMP AS INTEGER) + CAST(CAST((CHG_WT_TMP - CAST(CHG_WT_TMP AS INTEGER))*10 AS INTEGER) AS REAL)/10 AS CHG_WT
FROM TMP
WHERE ABS(CHG_WT)>=5
ORDER BY CHG_WT DESC, CODE DESC;