Structure of the BOOKS Table

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) ;