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#,
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%;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started