delete from ITEM
where ITEM_CODE not in (
  select ITEM_CODE from STOCK
  where LAST_DELIVERY_DATE < DATE('now', '-6 month')
    and ACTUAL_AMT = 0
)
;