OD
(Choose 1 answer)
A. Select itemID, itemName.MAX(bidPrice) MaxPriceOfBidder From auction_item i, bid b Where i.itemID = b.itemID
And sellerID = @memberIDGroup by itemID, itemName
B. Select itemID, itemName.MAX(bidPrice) MaxPriceOfBidder From auction_item i, bid b Where i.itemID= b.itemID And sellerID = @memberlDGroup by itemID
C. Select itemID, itemName.MAX(bidPrice) MaxPriceOfBidder From auction_item i, bid b Where i.itemID = b.itemID And bidderlD = @memberlD
Group by itemID
D. Select itemID, itemName.
MAX(bidPrice) MaxPriceOfBidder From auction_item i, bid b Where i. itemID = b.itemID
And bidderID = @memberlDGroup by itemID, itemName
Exit 16
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)
Which of the following SQL statement show the maximum bid price of one member (stored in variable @memberID) for each item
