Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
Danli Danli
wrote...
Go to Answer
Posts: 1536
Rep: 0 0
7 years ago
What is the error in the following SQL statement?
SELECT CustomerCity, Count(CustomerKey)
FROM Customer
GROUP BY CustomerCity
WHERE Count(CustomerCity) > 20
A) The GROUP BY clause is in the wrong place
B) You cannot use a WHERE clause when the criteria contains an aggregate function
C) There is nothing wrong with the query
D) None of the above
Textbook 
Hands-On Database

Hands-On Database


Edition: 2nd
Author:
Read 218 times
3 Replies
Computer Science Major @ The University of Texas at Austin
Replies
Answer verified by a subject expert
VenturiaVenturia
wrote...
#1
Posts: 265
Rep: 6 0
7 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

Danli Author
wrote...
#2
7 years ago
Tremendous help, thank u
Computer Science Major @ The University of Texas at Austin
wrote...
#3
3 years ago
..
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1290 People Browsing
 111 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Related Images
  
 2943
  
 299
  
 254