delete from
    ITEM
where
    item_code in(
        select
            item_code
        from
            stock
        where
            LAST_DELIVERY_DATE is not null
            and ACTUAL_AMT = 0
        group by
            item_code
        having
            max(LAST_DELIVERY_DATE) < date('2023-06-01', '-6 months')
    )
    and STOCK_MANAGEMENT_TYPE = 1;

delete from
    item
where
    item_code not in(
        select
            distinct item_code
        from
            stock
    )
    and STOCK_MANAGEMENT_TYPE = 1;