SQL Script to delete shipping network lines for any store(Organization)

We have lots of shipping network defined for one organizations. These shipping networks are attached to account segments for code combinations.

For last few years, lot of these organizations are closed and subsequently , there accounting valueset is disabled.

The normal process would be to delete lines in form "shipping network" when a store/Organization is closed / shut down.
We have not done this over the years, so we have issues in this form when searching for the setup for an inventory

Navigation   -->

Go to Shipping networks (Setup / Organizations / Shipping Networks)
Hit button FIND

Now you will get an error message for each line where the store is closed.