with s as (
  select 
    item_code, 
    max(last_delivery_date) last_delivery_date, 
    sum(actual_amt) actual_amt 
  from stock 
  group by 1
)

delete from item
where item_code in (
    select i.item_code
    from item i
    left join s on i.item_code = s.item_code
    where i.STOCK_MANAGEMENT_TYPE = 1
    and(
      s.item_code is null
      or
      (
        DATE('2023-06-01', '-6 month') > s.last_delivery_date
        and
        s.actual_amt = 0
      )
     )
)