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 = (
                select
                    ITEM_CODE
                from
                    STOCK
                group by
                    STOCK.ITEM_CODE
                having
                    max(date(coalesce(LAST_DELIVERY_DATE, '2023-06-01'))) <= date('2023-06-01', '-6 month')
                    and sum(ACTUAL_AMT) = 0
            )
        )
    )