delete from
    ITEM
where
    item_code in(
        select
            item_code
        from
            stock
        group by
            item_code
        having
            max(actual_amt) = 0
            and max(ifnull(LAST_DELIVERY_DATE,'2023-06-01')) <= 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;