​Contents of the BOOKS Table

question 12

Multiple Choice

​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

---

Definitions:

Bank Statement

A document issued by a bank that summarizes an account holder's transactions and financial activity over a specified period.

Checking Account

A bank account that allows for numerous withdrawals and deposits, intended primarily for daily transactions.

Check Register

A record book used to track checks written, deposits made, and the current balance of a checking account.

Endorser

Signature on the back of the check of the payee.