Structure of the CUSTOMERS Table

Multiple Choice

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