Question

CUSTOMERS(customer#, lastName, firstName, address, city, state, zip, referred) ORDERS( order#, customer#, orderDate, shipDate, ShipStreet, ShipCity, ShipZip) BOOKS (isbn, title, pubDate, publd, cost, retail, category) ORDERITEMS(order#, item#, isbn, quantity) Which of the following SQL statements will display the names of all customers who have purchased a copy of PLAGIARISM TOOLS (book title)? DS

SELECT lastName, firstName FROM customers NATURAL JOIN books WHERE title LIKE "%PLAG%;
SELECT lastName, firstName FROM customers c books b, orderitems oi WHERE title LIKE "%PLAG%;
SELECT lastName, firstName FROM customers c books b, orderitems of WHERE c.customer=o.customer AND c.orderëzoi.order# AND olisbn=bisbn AND title LIKE "%PLAG%;
none of the options

Answer 1

None of the provided SQL statements are correctly structured to find the names of customers who purchased 'PLAGIARISM TOOLS'. We need to join the customers, orders, orderitems, and books tables correctly and filter by the exact book title.

Step-by-step explanation:

To display the names of all customers who have purchased a copy of the book titled PLAGIARISM TOOLS, we need to join several tables: customers, orders, orderitems, and books. We should link these tables based on their relational fields and filter the results where the book title matches the one we're interested in. However, looking at the provided SQL statements, none of them are correctly structured to provide the desired output. They either lack proper joining syntax or have aliasing errors.

Here is a correction of the provided statements, assuming the schema given in the question is correct and that there is a missing ORDERS table link:

SELECT lastName, firstName
FROM customers c
JOIN orders o ON c.customer# = o.customer#
JOIN orderitems oi ON o.order# = oi.order#
JOIN books b ON oi.isbn = b.isbn
WHERE b.title = 'PLAGIARISM TOOLS';

It's important to mention that we do not use the % wildcard in the WHERE clause since we are looking for an exact match, not a pattern match.