with SUB as(
    select
        CHECKUP_DATE
        ,MEMBER_CODE
        ,WEIGHT
        ,lead(WEIGHT) over(partition by MEMBER_CODE order by CHECKUP_DATE desc) as PRE_WEIGHT
    from
        HEALTH_CHECKUP
    ),
SUB2 as (
    select
        CHECKUP_DATE as CK_DATE
        ,MEMBER_CODE
        ,round(cast(WEIGHT as real) - cast(PRE_WEIGHT as real),1) as CHG_WT
    from
        SUB
    where   
        abs(cast(WEIGHT as real) - cast(PRE_WEIGHT as real)) >= 5
    group by
        MEMBER_CODE
    having
        CHECKUP_DATE = MAX(CHECKUP_DATE)
    )
select 
    SUB2.CK_DATE
    ,SUB2.MEMBER_CODE as CODE
    ,MM.LAST_NAME || MM.FIRST_NAME as NAME
    ,SUB2.CHG_WT
from
    SUB2
    inner join MEMBER_MST as MM
        on SUB2.MEMBER_CODE=MM.MEMBER_CODE
order by
    SUB2.CHG_WT desc
    ,SUB2.MEMBER_CODE desc
    ;