Biology Forums - Study Force

Other Fields Homework Help Management Topic started by: plily1 on Jan 31, 2018



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!