delete from ITEM as t1
where exists(
    select * from ITEM as t2
    left join STOCK on t2.ITEM_CODE = STOCK.ITEM_CODE
    where STOCK.ITEM_CODE is null
    and t2.STOCK_MANAGEMENT_TYPE = 1
    and t1.ITEM_CODE = t2.ITEM_CODE
    group by STOCK.ITEM_CODE 
);

delete from ITEM as t1
where exists(
    select * from ITEM as t2
    inner join STOCK on t2.ITEM_CODE = STOCK.ITEM_CODE
    where t2.STOCK_MANAGEMENT_TYPE = 1
    and t1.ITEM_CODE = t2.ITEM_CODE
    group by t2.ITEM_CODE
    having max(LAST_DELIVERY_DATE)<=datetime('2023-06-01', '-6 months') and sum(ACTUAL_AMT = 0) 
);