Number of projects per status
SQL query for ArchX
Count the number of projects for each status.
SELECT project_status, COUNT(*) FROM project_statuses GROUP BY project_status
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.
- 14-day free trial
- No credit card needed