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