Question: Given the following query: SELECT DISTINCT zip, category FROM customers NATURAL JOIN orders NATURAL JOIN orderitems NATURAL JOIN books; Which of the following queries is
Given the following query:
SELECT DISTINCT zip, category
FROM customers NATURAL JOIN orders NATURAL JOIN orderitems
NATURAL JOIN books;
Which of the following queries is equivalent?
a. SELECT zip FROM customers
UNION
SELECT category FROM books;
b. SELECT DISTINCT zip, category
FROM customers c, orders o, orderitems oi, books b
WHERE c.customer# = o.customer# AND o.order# = oi.order#
AND oi.isbn = b.isbn;
c. SELECT DISTINCT zip, category
FROM customers c JOIN orders o
JOIN orderitems oi JOIN books b
ON c.customer# = o.customer#
AND o.order# = oi.order#
AND oi.isbn = b.isbn;
d. All of the above
e. None of the above
Step by Step Solution
3.44 Rating (151 Votes )
There are 3 Steps involved in it
e No... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c12127b9a_716476.pdf
180 KBs PDF File
1803_60b8c12127b9a_716476.docx
120 KBs Word File
