delete from
    ITEM
where
    STOCK_MANAGEMENT_TYPE = 1
    and not exists(
        select
            ITEM_CODE
        from
            STOCK
        where
            ITEM.ITEM_CODE = STOCK.ITEM_CODE
    )
    or ITEM_CODE in (
        select
            ITEM_CODE
        from
            STOCK
        group by
            ITEM_CODE
        having
            max(date(coalesce(LAST_DELIVERY_DATE, '2023-06-01'))) <= date('2023-06-01', '-6 month')
            and sum(ACTUAL_AMT) = 0
    );