SELECT
  CODE
 ,NAME
 ,COMP_RSLT
FROM(
SELECT
  ITEM.ITEM_CODE AS CODE
 ,ITEM.ITEM_NAME AS NAME
 ,CASE WHEN ITEM.USER_UPDATE_DATETIME = ITEM_HISTORY.USER_UPDATE_DATETIME THEN 'ADDED'
  ELSE 'UPDATED' END AS COMP_RSLT
FROM
  ITEM
INNER JOIN ITEM_HISTORY
ON ITEM.ITEM_CODE = ITEM_HISTORY.ITEM_CODE
AND ITEM_HISTORY.USER_UPDATE_DATETIME >= '2023/12/31' 
AND ITEM_HISTORY.USER_UPDATE_DATETIME <= '2024/4/1'
UNION ALL
SELECT
  ITEM_HISTORY.ITEM_CODE AS CODE
 ,ITEM_HISTORY.ITEM_NAME AS NAME
 ,'DELETED' AS COMP_RSLT
FROM
  ITEM_HISTORY
LEFT JOIN ITEM
ON ITEM_HISTORY.ITEM_CODE = ITEM.ITEM_CODE
WHERE ITEM.ITEM_CODE IS NULL
)
ORDER BY CODE DESC