Skip to main content

Peliqan

Try for free
Request a demo

Aproplan

Average number of documents per project

SQL query for Aproplan

Calculate the average number of documents per project.

SELECT AVG(documents_count) FROM (SELECT project_id, COUNT(id) AS documents_count FROM documents GROUP BY project_id) AS subquery

Try this query now in Aproplan

Aproplan data model

Aproplan
Projects

Aproplan
Workspaces

Aproplan
Points

Aproplan
Project Participants

Aproplan
Folders

Aproplan
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