WITH
    t_health_checkup as (
        SELECT 
            MEMBER_CODE, 
            CHECKUP_DATE, 
            WEIGHT,
            ROW_NUMBER() OVER (PARTITION BY MEMBER_CODE ORDER BY CHECKUP_DATE DESC) AS t_checkup
        FROM 
            HEALTH_CHECKUP
    ),
    weight_change as (
        SELECT 
            A.MEMBER_CODE as CODE,
            A.CHECKUP_DATE as CK_DATE,
            round(A.weight - B.weight, 1) as CHG_WT
        FROM 
            t_health_checkup as A
        JOIN 
            t_health_checkup as B ON A.MEMBER_CODE = B.MEMBER_CODE AND A.t_checkup = 1 AND B.t_checkup = 2
        WHERE 
            ABS(A.weight - B.weight) >= 4.95
    ),
    name_list as (
        SELECT
            MEMBER_CODE,
            LAST_NAME || FIRST_NAME as NAME
        FROM MEMBER_MST
    )
SELECT 
    CK_DATE,
    CODE,
    NAME,
    CHG_WT
FROM weight_change
LEFT JOIN  name_list ON weight_change.CODE = name_list.MEMBER_CODE
ORDER BY CHG_WT DESC, CODE DESC
;