delete
from ITEM
where
    (
        (ITEM_CODE not in (select distinct ITEM_CODE from STOCK))
        or
        (
            ITEM_CODE in (
                select ITEM_CODE from STOCK
                group by ITEM_CODE
                having sum(ACTUAL_AMT) = 0 and max(ifnull(LAST_DELIVERY_DATE, '2999-12-31')) <= date('2023-06-01', '-6 months')
            )
        )
    )
and
    STOCK_MANAGEMENT_TYPE = 1
;