× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
7
6
o
5
b
4
s
3
j
3
b
3
m
3
K
3
g
3
L
3
w
3
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
Jmini Jmini
wrote...
Go to Answer
Posts: 695
Rep: 0 0
6 years ago
Which of the following SQL statements will display the title of the books ordered by customer 1003?
 a. SELECT titleFROM customers NATURAL JOIN booksWHERE customer = 1003;
  b. SELECT titleFROM customers JOIN orders USING (customer)JOIN orderitems USING (order) JOIN books USING (isbn)WHERE customer = 1003;
  c. SELECT titleFROM customers JOIN orders ON (customer)JOIN orderitems ON (order) JOIN books ON (isbn)WHERE customer = 1003;
  d. both a and b
Read 99 times
2 Replies
Replies
Answer verified by a subject expert
rcollins105rcollins105
wrote...
#1
Top Poster
Posts: 914
Rep: 6 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

Jmini Author
wrote...
#2
6 years ago
This puts a Slight Smile on my face
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1045 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Related Images
  
 2797
  
 260
  
 204
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 405
Previous poll results: Which 'study break' activity do you find most distracting?