select item_code as code,
case
    when item_history.item_name is null then item.item_name
    when item.item_name = item_history.item_name then null
    else item.item_name
end as name
from item left outer join item_history using(item_code)
order by 1 desc;