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:

Own a Car

Refers to the possession or ownership of an automobile by individuals or households.

Standard Deviation

A metric that quantifies how spread out a dataset is around its average, determined by taking the square root of the variance.

Mean Score

The arithmetic average of a set of numerical values, calculated by adding all the scores together and dividing by the number of scores.

Weight Loss Program

A structured plan designed to help individuals lose weight, often including diet, exercise, and sometimes counseling or medication.