68 245
Assignments Done
Successfully Done
In November 2018

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

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's answer
Retrieves the States with more than one customer

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


No comments. Be first!

Leave a comment

Ask Your question

Privacy policy Terms and Conditions