What is the error in the following SQL statement?SELECT CustomerCity, Count(CustomerKey)FROM CustomerGROUP BY CustomerCityWHERE Count(CustomerCity) > 20
A) You cannot use a WHERE clause when the criteria contains an aggregate function
B) The GROUP BY clause is in the wrong place
C) There is nothing wrong with the query
D) Both A and B
D
Business
You might also like to view...
The fundamental premise underlying learning curve analysis is that:
A) tasks can be easily learned in organizations. B) organizations and people become better at their tasks as the tasks are repeated. C) learning takes place when people in organizations change. D) total labor costs decrease as the number of production units increases. E) doubling output cuts labor requirements per unit in half.
Business
Two NICs can successfully have the same manufactured physical address
Indicate whether the statement is true or false
Business