List of auto transactions in Wausau ordered by the transaction value in ascending order Q2: List of the number and average value of computer...

Q1: List of auto transactions in Wausau ordered by the transaction value in ascending order

Q2: List of the number and average value of computer requests in Wausau

Q3: List of names of suppliers offering both computers and autos (Do NOT use INTERSECT)

Q4: List of the consumer cities and number of consumers in each city

Q5: List of the value of product offers for each supplier issuing at least one offer

Q6: List of the name of consumers having at least 4 auto transactions

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

Q8: List the amount spent by each consumer for each product type he/she purchased

Q9: List of the number of orange offers in each city that offers oranges

Q10: List the cities where the number of computer offers is less than the number of computer requests