delete from 
    ITEM as it
where
    not exists(
        select
            it.ITEM_CODE
        from 
            STOCK as st
        where 
            it.ITEM_CODE = ST.ITEM_CODE
    )
    or 
    exists(
        select
            ITEM_CODE
        from 
            STOCK as st
        where
            it.ITEM_CODE = ST.ITEM_CODE 
        group by
            ITEM_CODE
        HAVING
            max(ifnull(LAST_DELIVERY_DATE,'2999-12-31')) <= date('2023-06-01','-6 MONTH') and sum(ACTUAL_AMT) = 0 
    )
    and STOCK_MANAGEMENT_TYPE = 1
;
select * from ITEM