Objects per person
SQL query for GeoFleet
List the number of objects associated with each person.
SELECT persons.name, COUNT(objects.id) FROM persons INNER JOIN objects ON persons.id = objects.person_id GROUP BY persons.name
GeoFleet data model
Objects
Markers
Persons
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