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

1 Expert Approved Answer
Step: 1 Unlock

e No... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12127b9a_716476.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12127b9a_716476.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!