SELECT
  CODE
 ,NAME
 ,COMP_RSLT
FROM(
SELECT
  ITEM.ITEM_CODE AS CODE
 ,ITEM.ITEM_NAME AS NAME
 ,'ADDED' AS COMP_RSLT
FROM
  ITEM
LEFT JOIN ITEM_HISTORY
ON ITEM.ITEM_CODE = ITEM_HISTORY.ITEM_CODE
WHERE ITEM_HISTORY.ITEM_CODE IS NULL
UNION ALL
SELECT
  ITEM.ITEM_CODE AS CODE
 ,ITEM.ITEM_NAME AS NAME
 ,'UPDATED' 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'
WHERE ITEM.USER_UPDATE_DATETIME <> ITEM_HISTORY.USER_UPDATE_DATETIME
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