DELETE FROM ITEM
WHERE ITEM_CODE =
(SELECT ITEM_CODE
FROM STOCK
WHERE
ITEM_CODE IS NULL
OR (LAST_DELIVERY_DATE <= '2022-12-01'
AND ACTUAL_AMT = 0)
AND STOCK_MANAGEMENT_TYPE = 1);