Chapter 9, Problem 3HOA

Explanation of Solution

SQL Query:

Refer to the “books”, “orders”, “orderitems” and “customers” tables in the JustLee Books database.

The SQL statement to perform the stated task with traditional approach is as follows:

SELECT DISTINCT c.lastname, c.customer#

 FROM books b, orders o, orderitems i, customers c

 WHERE c.customer# = o.customer#

  AND o.order# = i.order#

  AND i.isbn = b.isbn

  AND c.state = 'FL'

  AND b.category = 'COMPUTER';

The SQL statement to perform the stated task using the JOIN keyword is as follows:

SELECT DISTINCT c...