Skip to main content

Peliqan

Try for free
Request a demo

Aproplan Letsbuild

Number of projects per company

SQL query for Aproplan Letsbuild

Get the count of projects for each managed company.

SELECT managedcompanies.name, COUNT(projects.id) FROM managedcompanies LEFT JOIN projects ON managedcompanies.id = projects.company_id GROUP BY managedcompanies.name

Try this query now in Aproplan Letsbuild

Aproplan Letsbuild data model

Aproplan Letsbuild
Project Ids

Aproplan Letsbuild
Projects

Aproplan Letsbuild
Chapters

Aproplan Letsbuild
Languages

Aproplan Letsbuild
Issuetypes

Aproplan Letsbuild
Folders

Aproplan Letsbuild
Contactdetails

Aproplan Letsbuild
Documents

Aproplan Letsbuild
Lists

Aproplan Letsbuild
Points

Aproplan Letsbuild
Drawings

Aproplan Letsbuild
Forms

Aproplan Letsbuild
Managedcompanies

Aproplan Letsbuild
Companyusers

Aproplan Letsbuild
Countries

Aproplan Letsbuild
Professions

Aproplan Letsbuild
Persons

Aproplan Letsbuild
Formitems

Aproplan Letsbuild
Point Status

Aproplan Letsbuild
Users

Aproplan Letsbuild
Locations

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