Answer to Question #76382 in Databases | SQL | Oracle | MS Access for J

Question

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

Answer 1

Retrieves the States with more than one customer