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 the books ordered by customer# 1003?​

A) ​SELECT title
FROM customers NATURAL JOIN books
WHERE customer# = 1003;
B) ​SELECT title
FROM customers JOIN orders USING (customer#)
JOIN orderitems USING (order#) JOIN books USING (isbn)
WHERE customer# = 1003;
C) ​SELECT title
FROM customers JOIN orders ON (customer#)
JOIN orderitems ON (order#) JOIN books ON (isbn)
WHERE customer# = 1003;
D) ​both a and b