(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
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 b2.bidderlD = @memberlDGroup by itemID, itemName
Which of the following SQL statement show the current price, and maximum price of the given bidder (storedin variable @memberID) for each item
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 b1.bidderID = @memberlDAnd b2.bidderlD = @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 b1.bidderlD = @memberIDGroup by itemID, itemName
Exit 29
