Question: Part 2: Please write SQL Query for each statement below using the table schema.If you need any more information than this, please let me know.
Part 2: Please write SQL Query for each statement below using the table schema.If you need any more information than this, please let me know.
BA likes to have a set of statistics about the system as follows:
The most active seller (the one who has offered the most number of items)
The most active buyer (the one who has bought the most number of items)
The most popular seller (the one who sold the most number of items)
The most expensive item sold ever
The most expensive item available
The cheapest item sold ever
The cheapest item available
Table Schema is here:

Seller SellerID Street # and Name Email Telephone Zip State ocity ?Credit Card Number Card Owner Name Card Exp. Date Username Password Owner SellerID Item Description Quantity New Explained Refubrished Owner Name Initial Price Bid Start Date *Bid End Date Bid Start Time "Bid End Time Pictures ItemID Pictures Buyer Name Telephone Email Street # and Name city State ozip Username Password Card Exp. Date Card Owner Name Card Number Bidder BuyerD ItemID
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
