Sql question

[net4133678585]

Hello

Please help with this question below

What is the average size of a startup in each location , with average sizes above 500?

Hint

SELECT location, AVG(employees)FROM startupsGROUP BY locationHAVING AVG(employees) > 500;

https://www.codecademy.com/courses/learn-sql/projects/fakeapps

question is not clear , or i dont understad it right , Where is employee task in this question ?

[stetim94]

@net4133678585

with average sizes above 500

the size seems to refer to the amount of employees.

[_LinuS]

@net4133678585

SELECT location, AVG(employees)FROM startupsGROUP BY locationHAVING AVG(employees) > 500;

Hi there, the employees ist just a integer (number) displaying the total number of employees per startup.
This Query is using the AVG employee Integer from Startups Table and displays all Locations with more than 500 Employees.

SELECT location, AVG(employees) 
FROM startups
GROUP BY location
HAVING AVG(employees) > 500;