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

Question

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

Quizplus · Accepted Answer

The query filters the customers table to return only those rows where the city is either Boston, New York, or Denver, and selects the Customer_Name and telephone columns for those rows.

What Result Set Is Returned from the Following Query