Structure of the CUSTOMERS Table

question 5

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

---

Definitions:

Valentine's Day

An annual holiday celebrated on February 14th, known for expressing love and affection between intimate companions.

Product Item

A specific version or variation of a product that is distinct in its identifiable characteristics like size, flavor, or color.

Unique Brand

A brand that distinctively sets itself apart from competitors through its identity, values, and offerings.

Closely Related

Items, concepts, or entities that have a direct or strong connection to each other, often affecting each other's behavior or characteristics.