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:

Invoice

A document issued by a seller to a buyer that outlines the goods or services sold, their prices, and the payment terms.

Outstanding Balance

The amount of money owed that remains in a borrower's account, excluding interest and fees, that has not yet been paid.

Invoice

A document issued by a seller to a buyer, indicating items sold, prices, date of shipment, delivery and payment terms.

Payment

The act of giving money in exchange for goods or services.