Contents of the BOOKS table

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

Question

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

Quizplus · Accepted Answer

Line 4 is incomplete as there is no comparison operator after the (pubid,cost) subquery. It should have a comparison operator such as IN or = to make it a valid condition.

​Contents of the BOOKS Table

Contents of the BOOKS Table