I am trying to solve:

States where the number of suppliers exceeds the number of consumers?

Comparative list of supplier states and cities versus consumer states and states and cities with respective number of suppliers and consumers in each city?

The following is the database configuration:

Supplier(Supp_ID, Name, City, State)

Consumer(Con_ID, Name, City, State)

Product(Prod_ID, Name, Product_Category, Product_Line, Product_Packaging)

Offers(Supp_ID, Prod_ID, Quantity, Price)

Requests(Con_ID, Prod_ID, Quantity, Price)

Transactions(Tran_ID, Supp_ID, Con_ID, Prod_ID, Quantity, Price)

Any help would be great. Thanks!