warning: Creating default object from empty value in /var/www/drupal/modules/taxonomy/taxonomy.pages.inc on line 33.

team size

Number of Projects per Team Size in Rubyforge (June 2014)

Description:

This chart show the number of projects for each team size in Rubyforge.

Visualization:

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

SQL Script:

SELECT DISTINCT dev_count, COUNT( DISTINCT proj_unixname ) AS count
FROM rf_projects
WHERE datasource_id = [current]
GROUP BY dev_count
ORDER BY count DESC , dev_count

Number of Projects per Team Size in Objectweb (June 2014)

Description:

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

Visualization:

SQL Script:

SELECT DISTINCT dev_count, COUNT( DISTINCT proj_unixname ) AS count
FROM ow_projects
WHERE datasource_id = [current]
GROUP BY dev_count
ORDER BY count DESC , dev_count

Number of Projects per Team Size in Savannah (June 2014)

Description:

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

Visualization:

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

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

Description

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

Visualization

SQL Script

Use the results from the following query to create a temp table.

SELECT datasource_id, unixname, COUNT( dev_name ) AS dev_count
FROM gc_developer_projects
WHERE datasource_id = <current>
GROUP BY unixname;

Use the temp table for the following query.

SELECT dev_count, COUNT(unixname) AS Count
FROM gc_temp
WHERE datasource id = <current>
GROUP BY dev_count
ORDER BY Count DESC, dev_count;

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

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

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

Description

This chart shows the number of projects of each team size listed in Free Software Foundation.

Visualization

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

SQL Script

SELECT DISTINCT calc_dev_count, COUNT( DISTINCT proj_num ) AS count
FROM fsf_projects
WHERE datasource_id= <current>
GROUP BY calc_dev_count
ORDER BY count DESC , calc_dev_count;

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

Description

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

Visualization

SQL Script

SELECT DISTINCT dev_count, COUNT( DISTINCT proj_unixname ) AS count
FROM ow_projects
WHERE datasource_id = <current>
GROUP BY dev_count
ORDER BY count DESC , dev_count

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

Description

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

Visualization

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

SQL Script

SELECT DISTINCT dev_count, COUNT( DISTINCT proj_unixname ) AS count
FROM rf_projects
WHERE datasource_id = <current>
GROUP BY dev_count
ORDER BY count DESC , dev_count

As of June 2009, how many projects of each team size are listed in Sourceforge?

Description

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

Visualization

Projects listed as having NULL or 0 developers were disregarded (1432 and 1478 projects, respectively).

Sourceforge Developer Count Chart

SQL Script

SELECT DISTINCT dev_count, count(DISTINCT proj_unixname) AS count
FROM projects
WHERE datasource_id = <current>
GROUP BY dev_count
ORDER BY count DESC , dev_count;

As of June 2009, how many projects of each team size are listed in Objectweb?

Description

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

Visualization

Objectweb Developer Count Chart

SQL Script

SELECT DISTINCT dev_count, count(DISTINCT proj_unixname) AS count
FROM ow_projects
WHERE datasource_id = <current>
GROUP BY dev_count
ORDER BY count DESC , dev_count;

Syndicate content