Contents of the BOOKS table

-Based on the contents of the BOOKS table,which of the following SQL statements will display the title of all books published by the publisher of SHORTEST POEMS?
A) SELECT title FROM books WHERE pubid ANY (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS');
B) SELECT title FROM books WHERE pubid =ANY SELECT pubid FROM books WHERE title = 'SHORTEST POEMS';
C) SELECT title FROM books WHERE pubid IN (SELECT pubid,title FROM books WHERE title = 'SHORTEST POEMS');
D) none of the above

Question

​Contents of the BOOKS table
 
-​Based on the contents of the BOOKS table,which of the following SQL statements will display the title of all books published by the publisher of SHORTEST POEMS?
A) ​SELECT title FROM books WHERE pubid >ANY (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS'); 
B) ​SELECT title FROM books WHERE pubid =ANY SELECT pubid FROM books WHERE title = 'SHORTEST POEMS'; 
C) ​SELECT title FROM books WHERE pubid IN (SELECT pubid,title FROM books WHERE title = 'SHORTEST POEMS'); 
D) ​none of the above

Quizplus · Accepted Answer

The correct SQL syntax to achieve the desired result is not fully provided in any of the options. Options A and B use the `ANY` keyword incorrectly without a proper subquery syntax (missing parentheses in B), and option C uses the `IN` clause incorrectly by selecting two columns instead of just the `pubid`.

​Contents of the BOOKS Table

Contents of the BOOKS Table