​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:

Vision and Mission

Fundamental organizational statements where the vision articulates the desired future state and the mission describes the organization's purpose.

Succession Problem

The challenge an organization faces in identifying and preparing new leaders to replace those who are leaving.

Equally Capable

Being as competent or skilled in particular tasks or fields as others.

General Managers

Managers who are responsible for complex, multifunctional units.