[solved] – Question 76382

For table Customer_T used in class for the PineValleyFurniture database, what does the following statement do:

SELECT CustomerState, count(CustomerState)
FROM Customer_T
GROUP BY CustomerState
HAVING count(CustomerState) > 1

Retrieves the States with more than one customer

Retrieves the Customers with more than one state

Retrieves the States where there are more customers

Retrieves all the names of the customers with more states

Expert Answer

---