Answer (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 rep (stored in bid table)
Which of the following SQL statement show the maximum bid price of one member (stored in @memberID) for each item
A. Select itemID, itemName, MAX(bidPrice) MaxPriceOfBidder From auction_item i, bid b
Where i.itemID = b.itemID
And bidderID = @memberID
Group by itemID
B. Select itemID, itemName, MAX(bidPrice) MaxPriceOfBidder From auction item i, bid b And bidderID = @memberID
Where i.itemID = b.itemID
Group by itemID, itemName
C. Select itemID, itemName, MAX(bidPrice) MaxPriceOfBidder
From auction_item i, bid b Where i.itemID = b.itemID
And sellerID = @memberID
Group by itemID
D. Select itemID, itemName, MAX(bidPrice) MaxPriceOfBidder From auction item i, bid b
Where i.itemID = b.itemID And sellerID = @memberID
Group by itemID, itemName
Exit 44
