Contents of the BOOKS table

-Based on the contents of the BOOKS table,which line of the following SQL statement contains an error?
1 SELECT isbn,title
2 FROM books
3 WHERE pubid =
4 (SELECT pubid
5 FROM books
6 WHERE title = 'SHORTEST POEMS')
7 AND retail-cost
8 (SELECT AVG(retail-cost)
9 FROM books);
A) Line 3
B) Line 5
C) Line 7
D) none of the above

Question

​Contents of the BOOKS table
 
-​Based on the contents of the BOOKS table,which line of the following SQL statement contains an error?
1 SELECT isbn,title
2 FROM books
3 WHERE pubid =
4 (SELECT pubid
5 FROM books
6 WHERE title = 'SHORTEST POEMS')
7 AND retail-cost >
8 (SELECT AVG(retail-cost)
9 FROM books);
A) ​Line 3 
B) ​Line 5 
C) ​Line 7 
D) ​none of the above

Quizplus · Accepted Answer

The SQL statement is correctly formed to select ISBN and title from a table named books where the pubid matches that of a book titled 'SHORTEST POEMS' and where the retail cost is greater than the average retail cost of all books in the table. There are no syntax errors in the lines mentioned.

​Contents of the BOOKS Table

Contents of the BOOKS Table