​Contents of the BOOKS Table

question 105

Multiple Choice

​Contents of the BOOKS table

-​Based on the contents of the BOOKS table,which of the following SQL statements will return an error message?

• A) ​SELECT title FROM books WHERE retail = (SELECT MAX(retail)FROM books);
• B) ​SELECT title FROM books WHERE retail IN (SELECT MAX(retail)FROM books);
• C) ​SELECT title FROM books WHERE retail > (SELECT MAX(retail)FROM books);
• D) ​none of the above