Using the tables below..I need help with the questions at the bottom.

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 Tran_ID | Supp_ID | Con_ID | Prod_ID | Price | Quantity

QUESTIONS:

--List of name of consumer and the supplier city where he/she spent the most.

--List of cheapest product(s) offered by each supplier and corresponding price.

--List of names of consumers having purchases from all supplier cities.