delete from item
where ITEM_CODE = (
select A.ITEM_CODE as ITEM_CODE from ITEM A 
left outer join 
                (select ITEM_CODE, sum(ACTUAL_AMT) from STOCK
                  where (LAST_DELIVERY_DATE > date('2023-06-01', '-6 months') or LAST_DELIVERY_DATE is null)
               group by ITEM_CODE) B 
on A.ITEM_CODE = B.ITEM_CODE
where STOCK_MANAGEMENT_TYPE = '1'
and B.ITEM_CODE is null
)