Title: Which of the following SQL statements will display the title and cost of each book stored in the ... Post by: BoyzGonWild on Jan 31, 2018 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, phoneFROM publisher, books; b. SELECT title, cost, contact, phoneFROM publisher JOIN booksUSING (pubid); c. SELECT title, cost, contact, phoneFROM publisher JOIN booksUSING (isbn); d. SELECT title, cost, contact, phoneFROM publisher JOIN booksUSING (contact); Title: Which of the following SQL statements will display the title and cost of each book stored in the ... Post by: leannaolsen on Jan 31, 2018 Content hidden
|