SELECT
	ITEM_CODE AS CODE,
	ITEM_NAME AS NAME,
	COMP_RSLT
FROM
		(SELECT ITEM_CODE, ITEM_NAME, 'DELETED' AS COMP_RSLT
		FROM (SELECT ITEM_CODE, ITEM_NAME FROM ITEM_HISTORY EXCEPT SELECT ITEM_CODE, ITEM_NAME FROM ITEM)
	UNION
		SELECT ITEM_CODE, ITEM_NAME, 'ADDED' AS COMP_RSLT
		FROM (SELECT ITEM_CODE, ITEM_NAME FROM ITEM EXCEPT SELECT ITEM_CODE, ITEM_NAME FROM ITEM_HISTORY)
	UNION
		SELECT H.ITEM_CODE, H.ITEM_NAME, 'UPDATED' AS COMP_RSLT
		FROM ITEM_HISTORY H
		WHERE H.USER_UPDATE_DATETIME <> (SELECT I.USER_UPDATE_DATETIME FROM ITEM I WHERE I.ITEM_CODE = H.ITEM_CODE))
ORDER BY
	CODE DESC;