​Contents of the BOOKS Table

question 97

Multiple Choice

​Contents of the BOOKS table

-​Based on the contents of the BOOKS table,which of the following SQL statements will display the title of all books published by the publisher of SHORTEST POEMS?

• A) ​SELECT title FROM books WHERE pubid >ANY (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS');
• B) ​SELECT title FROM books WHERE pubid =ANY SELECT pubid FROM books WHERE title = 'SHORTEST POEMS';
• C) ​SELECT title FROM books WHERE pubid IN (SELECT pubid,title FROM books WHERE title = 'SHORTEST POEMS');
• D) ​none of the above

---

Definitions:

Salvage Value

The foreseen market valuation of an asset at the lifespan’s end.

Present Values

The now-value of a forthcoming financial amount or cash flow pattern, discounted at a fixed rate of return.

Net Present Value Method

A financial analysis tool used to evaluate the profitability of an investment by calculating the difference between the present value of cash inflows and outflows.

Annual Return

The percentage of increase or decrease in an investment's value over a one-year period.