select a.ITEM_CODE as CODE , 
    case when a.ITEM_NAME != b.ITEM_NAME then  a.ITEM_NAME else NULL end as NAME 
        
from ITEM as a 
left outer join ITEM_HISTORY as b on a.ITEM_CODE = b.ITEM_CODE
order by 1 desc