Created Following Tables Sql Server Need Know Write Queries Get Following Information Acti Q37232555

I have created the following tables in SQL server:

I need to know how to write the queries to get the followinginformation:

The most active seller (the one who has offered the most numberof items)

• The most active buyer (the one who has bought the most numberof items)

• The most expensive item sold ever

• The most expensive item available

• The cheapest item sold ever

• The cheapest item available

User Pas sword FirstName LastName Telephone Email StreetNumber StreetName City oState CreditCard Username CardNumber ExpirationDate Seller Buyer

OR

 

OR