Question

CUSTOMERS(customer#, lastName, firstName, address, city, state, zip, referred)

ORDERS( order#, customer#, orderDate, shipDate, ShipStreet, ShipCity, ShipZip)
BOOKS (isbn, title, pubDate, pubId, 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)?

a.SELECT lastName, firstName FROM orders o, customers c, books b, orderitems oi WHERE c.customer#=o.customer# AND o.order#=oi.order# AND oi.isbn=b.isbn AND title LIKE ‘%PLAG%’;

b.SELECT lastName, firstName FROM customers c, books b, orderitems oi WHERE title LIKE ‘%PLAG%’;

c.none of the options

d.SELECT lastName, firstName FROM customers NATURAL JOIN books WHERE title LIKE ‘%PLAG%’;

Answer 1

The correct SQL statement is option A: SELECT lastName, firstName FROM orders o, customers c, books b, orderitems oi WHERE c.customer#=o.customer# AND o.order#=oi.order# AND oi.isbn=b.isbn AND title LIKE '%PLAG%'; Option A is correct.

Step-by-step explanation:

The correct SQL statement to display the names of all customers who have purchased a copy of 'PLAGIARISM TOOLS' (book title) is option A:

SELECT lastName, firstName FROM orders o, customers c, books b, orderitems oi WHERE c.customer#=o.customer# AND o.order#=oi.order# AND oi.isbn=b.isbn AND title LIKE '%PLAG%';

This statement joins the customers, orders, books, and orderitems tables using appropriate table aliases and the necessary join conditions. It also includes a search condition to filter the books by the title 'PLAGIARISM TOOLS'.

The question revolves around an SQL query that is intended to find the names of all customers who have purchased a particular book titled ‘PLAGIARISM TOOLS’. The correct answer to this question is the following SQL statement:

SELECT lastName, firstName FROM orders o, customers c, books b, orderitems oi WHERE c.customer#=o.customer# AND o.order#=oi.order# AND oi.isbn=b.isbn AND title LIKE ‘%PLAG%’;

This SQL statement effectively links four tables that are necessary to retrieve the required information: customers, orders, books, and order items. It does so by correlating the customer number and order number among the tables and filtering the records where the book title contains the word ‘PLAG’.