delete from ITEM
where
 not exists
  (
   select
    *
   from
    STOCK
  )
  and
 ITEM_CODE in
  (
   select
    ITEM_CODE
   from
    STOCK
   where
    ACTUAL_AMT = 0
   group by
    ITEM_CODE
   having
    MAX(LAST_DELIVERY_DATE) >= DATE('2023-06-01', '-6 months')
  )
  and
 STOCK_MANAGEMENT_TYPE = 1
;