Skip to main content

Peliqan

Try for free
Request a demo

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

Try this query now in Aproplan

Aproplan data model

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