Number of visits per project - Archisnapper SQL Query - Peliqan

Number of visits per project

SQL query for Archisnapper

Get the number of visits for each project.

SELECT p.project_name, COUNT(v.visit_id) FROM projects p JOIN visits v ON p.project_id = v.project_id GROUP BY p.project_name

Archisnapper data model

Projects

Visits

Observations

Contacts

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.