Which of the following will select the highest-priced record per item
a. select item, brand, price from items where price = (select max(price) from items)
b. select * from items where price in (select max(price) from items group by item)
c. select item, brand, max(price) as highest_price from items group by item
d. select item, brand, price from items where price = (select max(price) from items) order by item