Question: Which of the following queries is valid? a. SELECT b.title, b.retail, o.quantity FROM books b NATURAL JOIN orders od NATURAL JOIN orderitems o WHERE od.order#

Which of the following queries is valid?

a. SELECT b.title, b.retail, o.quantity

FROM books b NATURAL JOIN orders od

NATURAL JOIN orderitems o

WHERE od.order# = 1005;

b. SELECT b.title, b.retail, o.quantity

FROM books b, orders od, orderitems o

WHERE orders.order# = orderitems.order#

AND orderitems.isbn = books.isbn

AND od.order# = 1005;

c. SELECT b.title, b.retail, o.quantity

FROM books b, orderitems o

WHERE o.isbn = b.isbn

AND o.order# = 1005;

d. None of the above

Step by Step Solution

3.50 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

c SELECT btitle bret... 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_60b8c12127a38_716468.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12127a38_716468.docx

120 KBs Word File

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