DELETE FROM ITEM AS I
WHERE NOT EXISTS
(SELECT ITEM_CODE FROM STOCK AS S WHERE S.ITEM_CODE = I.ITEM_CODE);

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