select
ITEM_CODE CODE,
case when
(select I.ITEM_NAME
from ITEM I
inner join ITEM_HISTORY IH on I.ITEM_CODE = IH.ITEM_CODE
where I.ITEM_NAME = IH.ITEM_NAME)  is not null then null
when (select I.ITEM_NAME
from ITEM I
inner join ITEM_HISTORY IH on I.ITEM_CODE = IH.ITEM_CODE
where I.ITEM_NAME != IH.ITEM_NAME) is not null then I.ITEM_NAME
end as NAME

from ITEM I

order by ITEM_CODE desc