delete from
    STOCK
where
    ITEM_CODE in(
        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
    )
    and exists(
        select
            ITEM_CODE
        from
            item
        where
            STOCK.ITEM_CODE = item.ITEM_CODE
            and STOCK_MANAGEMENT_TYPE = 1
    );

delete from
    item
where
    (
        ITEM_CODE not in(
            select
                ITEM_CODE
            from
                STOCK
        )
        and STOCK_MANAGEMENT_TYPE = 1
    )