DELETE FROM ITEM
WHERE ITEM_CODE NOT IN (SELECT ITEM_CODE FROM STOCK)
AND STOCK_MANAGEMENT_TYPE = 1;

DELETE FROM ITEM
WHERE ITEM_CODE IN
(SELECT ITEM_CODE FROM STOCK
 GROUP BY ITEM_CODE
 HAVING MAX(DATE(LAST_DELIVERY_DATE)) <= DATE('2023-06-01', '-6 months')
 AND MAX(ACTUAL_AMT) = 0
)
AND STOCK_MANAGEMENT_TYPE = 1;