Question

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_person, phone_number FROM BOOKS;

b) SELECT title, cost FROM BOOKS;

c) SELECT title, cost, contact_person FROM BOOKS;

d) SELECT title, phone_number FROM BOOKS;

Answer 1

None of the given options is correct because the contact person and phone number are likely in the PUBLISHER table, not the BOOKS table. A SQL join between BOOKS and PUBLISHER tables is necessary to fetch the required information.

Step-by-step explanation:

To 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, none of the provided options are correct as given. This is because the information about the contact person and phone number is likely stored in the PUBLISHER table, not the BOOKS table as implied by the options. The correct SQL statement would need to join the BOOKS table with the PUBLISHER table to gather all of the required information. A possible correct SQL statement (not provided in the options) could look like:

SELECT B.title, B.cost, P.contact_person, P.phone_number
FROM BOOKS B
JOIN PUBLISHER P ON B.publisher_id = P.id;

This statement assumes that there is a relational column such as publisher_id linking the two tables.