Total number of projects per country
SQL query for Aproplan
Get the total number of projects per country.
SELECT countries.name AS country, COUNT(projects.id) AS total_projects FROM countries LEFT JOIN projects ON countries.id = projects.country_id GROUP BY countries.name
Aproplan data model
Projects
Workspaces
Points
Project Participants
Folders
Forms
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