Structure of the CUSTOMERS table

Structure of the ORDERS table
Structure of the ORDERITEMS table
Structure of the BOOKS table
-Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?
A) SELECT title FROM books NATURAL JOIN orderitems WHERE qty 1;
B) SELECT title FROM books JOIN orderitems WHERE qty 1;
C) SELECT title FROM books JOIN orderitems ON (isbn)JOIN orders ON (order#) WHERE qty1;
D) SELECT title FROM books JOIN orderitems USING(isbn);

Question

Structure of the CUSTOMERS table
  ​
Structure of the ORDERS table
  Structure of the ORDERITEMS table
  Structure of the BOOKS table
-Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?​
A) ​SELECT title FROM books NATURAL JOIN orderitems WHERE qty > 1; 
B) ​SELECT title FROM books JOIN orderitems WHERE qty > 1; 
C) ​SELECT title FROM books JOIN orderitems ON (isbn)JOIN orders ON (order#) WHERE qty>1; 
D) ​SELECT title FROM books JOIN orderitems USING(isbn);

Quizplus · Accepted Answer

Option A correctly uses the NATURAL JOIN operation to join the books and orderitems tables based on the common column(s) between them and filters the result to show titles of books where the quantity (qty) ordered is greater than 1, indicating multiple copies were requested in a single order.

Structure of the CUSTOMERS Table