Average number of tasks per project - ArchX SQL Query - Peliqan

Average number of tasks per project

SQL query for ArchX

Calculate the average number of tasks per project.

SELECT AVG(num_tasks) FROM (SELECT project_id, COUNT(*) AS num_tasks FROM tasks GROUP BY project_id) AS task_counts

ArchX data model

Companies

Projects

Project Plots

Invoices

Contracts

Contract Phases

Project Statuses

Tasks

Users

Users Disabled

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.