As of June 2009, how many projects of each team size are listed in Freshmeat?
Description
This chart shows the number of projects of each team size listed in Freshmeat.
Visualization
Projects listed as having 0 developers were disregarded (332 projects).
SQL Script
SELECT DISTINCT calc_dev_count, count(DISTINCT project_id) AS count
FROM fm_projects
WHERE datasource_id= <current>
GROUP BY calc_dev_count
ORDER BY count DESC, calc_dev_count;
Attachment | Size |
---|---|
fmDeveloperCount.gif | 9.67 KB |
Data Resources:
- Log in to post comments