(Choose 1 answer)
There is an auction database consists the following tables:
Member(memberID, memberName)Auction_item(itemID, itemName, sellerID)
Bid(itemID, bidderID, bidPrice)
All registered members can put up item to sell (stored in auction_tem table), and can bid repeatedly one item
stored in bid table)(
Current price of an item is maximum bidPrice
Which of the following SQL statement show the current price, and maximum price of the given bidder (storedin variable @memberID) for each item
A. Select itemID, itemName, MAX(b1.price) CurrentPrice, MAX(b2.bidPrice) MaxPriceOfBidder
From auction item i, bid b1, bid b2
Where i.itemID=b1.itemID
And i.itemID = b2.itemID
And b1.bidderID = @memberID
Group by itemID, item Name
B. Select itemID, itemName, MAX(b1.price) CurrentPrice, MAX(b2.bidPrice) MaxPriceOfBidder
From auction_item i, bid b1, bid b2 Where i.itemID = b1.itemID
And i.itemID = b2.itemID
And b2.bidderID = @memberIDGroup by itemID, itemName
C. Select itemID, itemName, MAX(b1.price) CurrentPrice, MAX(b2.bidPrice) MaxPriceOfBidder From auction_item i, bid b1, bid b2
Where i.itemID = b1.itemID And i.itemID = b2.itemID
And h1 hidderID = @memberID
3
