Biology Forums - Study Force

Other Fields Homework Help Management Topic started by: banoshaher on Jan 31, 2018



Title: Which of the following SQL statements will display the publisher name, book title, and retail price ...
Post by: banoshaher on Jan 31, 2018
Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than 35.95?
 a. SELECT name, title, retailFROM books, publisherWHERE cost > 35.95;
  b. SELECT name, title, retailFROM books NATURAL JOIN publisherWHERE cost > 35.95;
  c. SELECT p.name, b.title, b.retailFROM books b NATURAL JOIN publisher pWHERE b.cost > 35.95;
  d. none of the above


Title: Which of the following SQL statements will display the publisher name, book title, and retail price ...
Post by: mich3093 on Jan 31, 2018
b


Title: Which of the following SQL statements will display the publisher name, book title, and retail price ...
Post by: banoshaher on Jan 31, 2018
I know you spent a lot of time finding this because I swear it wasn't in my textbook