× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
1
a
1
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
plily1 plily1
wrote...
Go to Answer
Posts: 637
Rep: 0 0
6 years ago
Based on the contents of the CUSTOMERS table, which SQL statement will display the customers residing in the same state as customer1013?
 a. SELECT customer FROM customers WHERE customer =(SELECT state FROM customers WHERE state = 'NJ');
  b. SELECT customer FROM customers WHERE state =(SELECT state FROM customers WHERE customer=1013);
  c. SELECT customer FROM customers WHERE customer IN(SELECT state FROM customers WHERE state = 'NJ');
  d. SELECT customer FROM customers WHERE state EXISTS(SELECT state FROM customers WHERE customer=1013);
Read 76 times
2 Replies
Replies
Answer verified by a subject expert
npalmierinpalmieri
wrote...
#1
Top Poster
Posts: 886
Rep: 4 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

plily1 Author
wrote...
#2
6 years ago
Thank you for answering correctly!
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  941 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Related Images
  
 345
  
 364
  
 377
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 485
Previous poll results: How often do you eat-out per week?