DELETE FROM ITEM WHERE ITEM_CODE = (
SELECT ITEM.ITEM_CODE
FROM ITEM LEFT OUTER JOIN STOCK ON STOCK.ITEM_CODE = ITEM.ITEM_CODE
WHERE STOCK.STOCK_TYPE IS NOT NULL
AND DATE(STOCK.LAST_DELIVERY_DATE, '-2023 YEARS', '-6 MONTHS', '-1 DAYS') BETWEEN 0 AND '-0001-06-01'
GROUP BY STOCK.ITEM_CODE
HAVING SUM(STOCK.ACTUAL_AMT) = 0
)