Top Posters
Since Sunday
c
5
j
5
a
5
L
5
f
5
j
5
D
4
k
4
y
4
t
4
h
4
l
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 223 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
  909 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 179
  
 323
  
 267
Your Opinion
How often do you eat-out per week?
Votes: 80
Previous poll results: Which industry do you think artificial intelligence (AI) will impact the most?