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 AS I
WHERE EXISTS (SELECT ITEM_CODE FROM STOCK AS S WHERE S.ITEM_CODE = I.ITEM_CODE GROUP BY ITEM_CODE
HAVING MAX(LAST_DELIVERY_DATE) < date('2023-06-01', 'localtime', '-6 months')
AND MAX(ACTUAL_AMT) = 0)
AND I.STOCK_MANAGEMENT_TYPE = 1;