This is an old revision of the document!
<< Back to List of Activity Metrics
SELECT count(distinct pull_request_id) as num_opened, projects.name as project_name, projects.url as url FROM msr14.pull_request_history join pull_requests on pull_request_history.pull_request_id = pull_requests.id join projects on pull_requests.base_repo_id = projects.id where action = 'opened' group by projects.id
SELECT count(distinct pull_request_id) as num_closed, projects.name as project_name, projects.url as url FROM msr14.pull_request_history join pull_requests on pull_request_history.pull_request_id = pull_requests.id join projects on pull_requests.base_repo_id = projects.id where action = 'closed' group by projects.id