Title: Based on the contents of the CUSTOMERS table, which SQL statement will display the customers ... Post by: plily1 on Jan 31, 2018 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); Title: Based on the contents of the CUSTOMERS table, which SQL statement will display the customers ... Post by: npalmieri on Jan 31, 2018 Content hidden
Title: Based on the contents of the CUSTOMERS table, which SQL statement will display the customers ... Post by: plily1 on Jan 31, 2018 Thank you for answering correctly!
|