Structure of the CUSTOMERS table

Structure of the ORDERS table
Structure of the ORDERITEMS table
Structure of the BOOKS table
-To display the name of each customer and the ISBN of each book purchased by the customers would require how many joins in the FROM clause of the SQL statement?
A) 4
B) 3
C) 2
D) 1

Question

Structure of the CUSTOMERS table
  ​
Structure of the ORDERS table
  Structure of the ORDERITEMS table
  Structure of the BOOKS table
-​To display the name of each customer and the ISBN of each book purchased by the customers would require how many joins in the FROM clause of the SQL statement?
A) ​4 
B) ​3 
C) ​2 
D) ​1

Quizplus · Accepted Answer

To display the name of each customer and the ISBN of each book purchased, you would need to join the Customers table with the Orders table, and then join the result with the Books table. This requires 2 joins.

Structure of the CUSTOMERS Table