SQL, the tables are as follows with the questions below.

Thanks for any help!

Consumer Table Tb_Consumers Con_ID | Name | City

Offers Table Tb_Offers Supp_ID | Prod_ID | Price | Quantity

Product Table Tb_Products Prod_ID | Name | MU

Requests Table Tb_Requests Con_ID | Prod_ID | Price | Quantity

Supplier Table Tb_Supplier Supp_ID | Name | City

Transaction Table

Tb_Transactions

Tran_ID | Supp_ID | Con_ID | Prod_ID | Price | Quantity

QUESTIONS:

-- List of names of consumers located in Stevens Point or Chicago or not having Transactions with suppliers from Wausau or Stevens Point?

-- List of names of products for which the total offered quantities exceeds total requested quantities?

-- List of names of consumers having transactions with all suppliers