Contents of the BOOKS table

-Based on the contents of the BOOKS table,which line in the following SQL statement contains an error?
1 SELECT title
2 FROM books
3 WHERE pubid EXISTS IN
4 (SELECT pubid
5 FROM books
6 WHERE retail 41.95);
A) Line 1
B) Line 3
C) Line 4
D) Line 6

Question

​Contents of the BOOKS table
 
-​Based on the contents of the BOOKS table,which line in the following SQL statement contains an error?
1 SELECT title
2 FROM books
3 WHERE pubid EXISTS IN
4 (SELECT pubid
5 FROM books
6 WHERE retail > 41.95);
A) ​Line 1 
B) ​Line 3 
C) ​Line 4 
D) ​Line 6

Quizplus · Accepted Answer

The keyword "EXISTS" should come after the subquery in Line 3. The correct syntax is "WHERE EXISTS (SELECT ...)" not "WHERE pubid EXISTS IN (SELECT ...)".

​Contents of the BOOKS Table

Contents of the BOOKS Table