Number of people in each location
SQL query for AllGravy
Count the number of people in each location.
SELECT location_id, COUNT(person_id) AS num_people FROM peoples GROUP BY location_id
AllGravy data model
Employee Roles
Locations
Pulse Answers
Peoples
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed