--delete from item
--where item_code in (
    select i.item_code
    from item i
    left join 
      (select item_code, max(last_delivery_date) last_delivery_date, sum(actual_amt) actual_amt from stock group by 1) 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
      )
     )
--)