Structure of the BOOKS table

Structure of the PUBLISHER table
-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, retail FROM books, publisher WHERE cost 35.95;
B) SELECT name, title, retail FROM books NATURAL JOIN publisher WHERE cost 35.95;
C) SELECT p.name, b.title, b.retail FROM books b NATURAL JOIN publisher p WHERE b.cost 35.95;
D) none of the above

Question

Structure of the BOOKS table
  
Structure of the PUBLISHER table
-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, retail FROM books, publisher WHERE cost > 35.95; 
B) SELECT name, title, retail FROM books NATURAL JOIN publisher WHERE cost > 35.95; 
C) SELECT p.name, b.title, b.retail FROM books b NATURAL JOIN publisher p WHERE b.cost > 35.95; 
D) none of the above

Quizplus · Accepted Answer

The Answer of  
Structure of the BOOKS table
  
Structure of the PUBLISHER table
-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, retail FROM books, publisher WHERE cost > 35.95; 
B) SELECT name, title, retail FROM books NATURAL JOIN publisher WHERE cost > 35.95; 
C) SELECT p.name, b.title, b.retail FROM books b NATURAL JOIN publisher p WHERE b.cost > 35.95; 
D) none of the above

Structure of the BOOKS Table