Structure of the CUSTOMERS Table

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 names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY?

A) SELECT lastname, firstname
FROM customers NATURAL JOIN books
WHERE title LIKE '%BUSI%';
B) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi
WHERE title LIKE '%BUSI%';
C) SELECT lastname, firstname FROM customers c, books b, orders o, orderitems oi
WHERE c.customer# = o.customer# AND o.order# = oi.order# AND
Oi) isbn = b.isbn AND title LIKE '%BUSI%';
D) none of the above