DELETE FROM STOCK AS A 
  WHERE NOT EXISTS(SELECT * FROM ITEM B WHERE B.ITEM_CODE = A.ITEM_CODE AND B.STOCK_MANAGEMENT_TYPE = 1);
  
DELETE FROM STOCK AS A 
  WHERE     EXISTS(SELECT * FROM ITEM B WHERE B.ITEM_CODE = A.ITEM_CODE AND B.STOCK_MANAGEMENT_TYPE = 1)
  AND A.LAST_DELIVERY_DATE <= datetime('2023-06-01', '-6 months') AND ACTUAL_AMT = 0;
--SELECT * FROM STOCK