Structure of the BOOKS Table

question 95

Multiple Choice

Structure of the BOOKS table
Structure of the PUBLISHER table
-​Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table,as well as the name of the contact person and the phone number to call to reorder the book?

• A) SELECT title,cost,contact,phone FROM publisher,books;
• B) SELECT title,cost,contact,phone FROM publisher JOIN books USING (pubid);
• C) SELECT title,cost,contact,phone FROM publisher JOIN books USING (isbn);
• D) SELECT title,cost,contact,phone FROM publisher JOIN books USING (contact);

---

Definitions:

Adjusted Basis

The original cost of a property adjusted for improvements, depreciation, and certain other factors, used to calculate capital gains or losses.

Fair Market Value

The price that property would sell for on the open market, often used in the context of real estate and tax assessments.

Recognized Gain

The amount of gain that is subject to tax in the year of a transaction.

Realized Gain

The profit earned from the sale of an asset, such as stocks, bonds, or real estate, which becomes taxable when the asset is sold.