Sql question


Please help with this question below

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


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


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

the size seems to refer to the amount of employees.

1 Like

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;