with max_table as (

select 
*   
  
from 
    health_checkup 

group by 
    MEMBER_CODE
    
having 
    checkup_date = max(checkup_date)
) ,diff as (
select 
    a.checkup_date as CK_DATE ,a.member_code as CODE , round(a.weight-b.weight,1) as CHG_WT

from    
    max_table as a  left join  health_checkup as b on a.member_code = b.member_code 

where 
    CK_DATE != b.checkup_date
    and round(abs(a.weight-b.weight),2) >= 5.0 
)
select diff.Ck_date,diff.CODE,(LAST_NAME || FIRST_NAME) as NAME, diff.CHG_WT
from diff left join MEMBER_MST
on diff.code = member_mst.member_code

order by    
    CHG_WT desc , CODE desc
    
    

--(LAST_NAME || FIRST_NAME) as NAME
 -- max(checkup_date) as CK_DATE  , MEMBER_CODE as CODE  , weight - (select weight )