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);

The answer is "Option 4"

Explanation:

In the given question line 4 is incorrect because it uses the select command, which selects "pubid and cost" that is already defined inline 3. This statement selects one or more a collection of records from the tables. It also recovers more row across any table that server and correct choices can be described as follows:  

you are welcome for my answer it is b⇔⇒⊕