I need help with a few questions, not all need to be answered by any means but I am struggling on a few of them. The tables are below with the column names, and the questions will be at the bottoms. 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 the name of consumers having at least 5 computer transactions.

* List the product name and the number of offers and requests for each product.

* List of the name of consumers having purchased at least 3 different products whose suppliers are from Wausau.

* List the amount spent by each consumer for each product type he/she purchased, ordered by consumer name and product name.