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