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