(Choose 1 answer)
There is an auction database consists the following tables:
Member(memberID, memberName)
Auction_item (itemID, itemName, sellerID, endTime)
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 for each item
A. Select itemID, itemName, MAX(bidPrice) CurrentPrice From auction_item i, bid b Where i.itemID = b.itemID Group by itemID
B. Select itemID, itemName, MAX(bidPrice) CurrentPrice From auction_item i, bid b Where i.itemID = b.itemID
Group by itemName
Exi Q: 31
