(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
C. Select itemID, itemName, MAX(bidPrice) CurrentPrice
From auction_item i, bid b
Where i.itemID = b.itemID Group by itemID, itemName
Exit 5
