What Result Set Is Returned from the Following Query

question 67

Multiple Choice

What result set is returned from the following query?
Select customer_name,telephone
From customers
Where city in ('Boston','New York','Denver') ;

• A) The customer_name and telephone of all customers
• B) The customer_name and telephone of all customers living in either Boston, New York or Denver
• C) The customer_name and telephone of all customers living in Boston and New York and Denver
• D) The customer_name of all customers living in Boston, New York or Denver

---

Definitions:

University Students

Individuals enrolled in an institution of higher education to pursue various academic degrees.

Low Income Housing

Affordable housing targeted towards individuals or families with low household income.

P-value

A statistical measure that indicates the probability of the observed data given the null hypothesis is true, used to determine significance.

Sampling Variation

The variation in statistics (like mean, median) from one sample to another taken from the same population, attributable to the random nature of sampling.