Structure of the BOOKS Table

question 131

Multiple Choice

Structure of the BOOKS table

Structure of the PUBLISHER table
-Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than $35.95?

• A) SELECT name, title, retail FROM books, publisher WHERE cost > 35.95;
• B) SELECT name, title, retail FROM books NATURAL JOIN publisher WHERE cost > 35.95;
• C) SELECT p.name, b.title, b.retail FROM books b NATURAL JOIN publisher p WHERE b.cost > 35.95;
• D) none of the above

---

Definitions:

Economic Profits

The profit a firm makes after deducting both its explicit and implicit costs, reflecting the total opportunity costs of all resources used.

Yearly Return

The total gain or loss on an investment over a one-year period, expressed as a percentage of the investment's initial value.

Variable Costs

Expenditures that adjust in relation to the level of production.

Fixed Costs

Costs that do not vary with the level of output produced by a firm, such as rent, salaries, and insurance premiums.