Contents of the BOOKS Table​

Contents of the BOOKS table​

-Based upon the contents of the BOOKS table,which of the following will display the retail price of the most expensive book provided by publisher 3?​

A) ​SELECT MAX(retail)
FROM books
GROUP BY pubid;
B) SELECT MAXIMUM(retail)
FROM books
WHERE pubid = 3;​
C) SELECT MAX(retail)
FROM books
WHERE pubid = 3;
D) ​SELECT MAXIMUM(retail)
FROM books
HAVING pubid = 3;