select 
    item.item_code CODE,
    case when hi.item_code is null or item.item_name<>hi.item_name then item.item_name
        else 'NULL' end  as NAME
    
     from 
                                                 item left join item_history hi on  item.item_code=hi.item_code
order by 1 desc