Contents of the BOOKS Table​

question 51

Multiple Choice

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;