SELECT ITEM_CODE CODE
	,ITEM_NAME NAME
	,COMP_RSLT
FROM (
	SELECT 
		I.ITEM_CODE
		,I.ITEM_NAME
		,CASE WHEN IH.ITEM_CODE IS NULL THEN 'ADDED'
		 WHEN I.USER_UPDATE_DATETIME <> IH.USER_UPDATE_DATETIME THEN 'UPDATED'
		 ELSE NULL
		END COMP_RSLT
	FROM ITEM I
		LEFT JOIN ITEM_HISTORY IH
		ON I.ITEM_CODE = IH.ITEM_CODE
	WHERE I.USER_UPDATE_DATETIME BETWEEN '2023-12-31' AND '2024-04-01'
	UNION
	SELECT 
		IH.ITEM_CODE
		,IH.ITEM_NAME
		,CASE WHEN I.ITEM_CODE IS NULL THEN 'DELETED'
		 WHEN I.USER_UPDATE_DATETIME <> IH.USER_UPDATE_DATETIME THEN 'UPDATED'
		 ELSE NULL
		END COMP_RSLT
	FROM ITEM_HISTORY IH
		LEFT JOIN ITEM I
		ON IH.ITEM_CODE = I.ITEM_CODE
)
WHERE COMP_RSLT IS NOT NULL
ORDER BY ITEM_CODE DESC