× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
1
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
Micky5490! Micky5490!
wrote...
Go to Answer
Posts: 660
Rep: 0 0
6 years ago
Which of the following SQL statements will display the names of all customers who have purchased a copy of E-BUSINESS THE EASY WAY?
 a. SELECT lastname, firstnameFROM customers NATURAL JOIN booksWHERE title LIKE 'BUSI';
  b. SELECT lastname, firstnameFROM customers c, books b, orders o, orderitems oiWHERE title LIKE 'BUSI';
  c. SELECT lastname, firstnameFROM customers c, books b, orders o, orderitems oiWHERE c.customer = o.customer AND o.order = oi.order ANDoi.isbn = b.isbn AND title LIKE 'BUSI';
  d. none of the above
Read 69 times
1 Reply
Replies
Answer verified by a subject expert
cedd123cedd123
wrote...
#1
Top Poster
Posts: 917
Rep: 6 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

Micky5490! Author
wrote...

6 years ago
Thanks for your help!!
tcat
wrote...

Yesterday
Good timing, thanks!
Danivalda
wrote...

2 hours ago
This calls for a celebration Person Raising Both Hands in Celebration
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1081 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 2235
  
 412
  
 401
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 405
Previous poll results: What percentage of nature vs. nurture dictates human intelligence?