DBI202Xuất hiện trong 1 đề thi
There is an auction database consists the following tables: ```sql 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_item 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?
Các lựa chọn
A```sql
Select itemID, itemName, MAX(bidPrice) CurrentPrice
From auction_item i, bid b
Where i.itemID = b.itemID
Group by itemID
```
B```sql
Select itemID, itemName, MAX(bidPrice) CurrentPrice
From auction_item i, bid b
Where i.itemID = b.itemID
Group by itemName
```
C```sql
Select itemID, itemName, MAX(bidPrice) CurrentPrice
From auction_item i, bid b
Where i.itemID = b.itemID
Group by itemID, itemName
```
DKhông hiển thị trong ảnh.