with a as (
select
    ITEM_CODE 
    ,sum(ACTUAL_AMT) as amt_sum
    ,max(LAST_DELIVERY_DATE) as max_date
from STOCK
where LAST_DELIVERY_DATE is not null
group by ITEM_CODE
)
delete
from ITEM
where 
(
    not exists 
        (select ITEM_CODE 
        from STOCK
        shere STOCK.ITEM_CODE = ITEM.ITEM_CODE)
    or exists 
        (select ITEM_CODE from a
        where max_date <= date('2023-06-01','-6 month')
        and amt_sum = 0)
)
and STOCK_MANAGEMENT_TYPE = 1