Contents of the BOOKS Table​

question 61

Multiple Choice

Contents of the BOOKS table​

-Based on the contents of the BOOKS table,which of the following SQL statements will return the total profit generated by books provided by publisher 4?​

• A) ​SELECT TOTAL(retail-cost)FROM books WHERE pubid = 4;
• B) SELECT TOTAL(retail-cost)FROM books GROUP BY pubid;
• C) ​SELECT SUM(retail-cost)FROM books WHERE pubid = 4;
• D) SELECT SUM(retail-cost)FROM books GROUP BY pubid = 4;​

---

Definitions:

Distributed Leadership

A leadership approach in which multiple members of an organization share responsibility and power in decision-making processes.

Responsibility

The state or fact of being accountable or to blame for something, often involving an obligation to act.

Cohesiveness

The degree to which members are attracted to a group and motivated to remain a part of it.

Attracted

Drawn towards or interested in something or someone due to appealing qualities.