Contents of the CUSTOMERS Table​

question 39

Multiple Choice

Contents of the CUSTOMERS table​

-​Based on the contents of the CUSTOMERS table,which SQL statement will display the customers residing in the same state as customer#1013?

• 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);

---

Definitions:

ThedaCare

A community health system or organization, often recognized for its innovative approaches to healthcare and patient treatment processes.

CVP

Cost Volume Profit analysis, a financial model that helps companies understand how changes in costs and sales volume affect profits.

Diversified Market

Two or more customer segments with different needs and problems that bear no relationship to each other.

Customer Segments

Distinct groups of people who share similar needs or characteristics targeted by a business's products or services.