How many projects of each team size are listed in Savannah? (05-2011)

Submitted by Anonymous on May 25, 2011 - 3:43pm

Description

This chart shows the number of projects of each team size listed in Savannah.

Visualization

Projects listed as having 0 developers were disregarded (73 projects).

SQL Script

SELECT DISTINCT project_dev_count, COUNT( DISTINCT project_name ) AS count
FROM sv_projects
WHERE datasource_id= <current>
GROUP BY project_dev_count
ORDER BY count DESC , project_dev_count

AttachmentSize
Image icon 05-11-sv-team_size.png17.54 KB
Data Resources: 
Examples
Tags: 
team size
count
savannah