Community Health

Number of Comments per Issue

GHTorrent

SELECT avg(avg_num_comments), project_name
FROM
(
	SELECT count(comment_id) as avg_num_comments, projects.name as project_name, projects.id as project_id
	FROM msr14.issue_comments
		join issues on issue_comments.issue_id = issues.id
		join projects on issues.repo_id = projects.id
	GROUP BY projects.id, issues.id
) as comments_per_issue
GROUP BY project_id

  
  SELECT projects.name as project_name, COUNT(issue_comments.comment_id), DATE(issue_comments.created_at) AS date_commented
  FROM issue_comments
      JOIN issues ON issues.id = issue_comments.issue_id
      JOIN projects ON projects.id = issues.repo_id
      GROUP BY projects.id, date_commented

  SELECT projects.name as project_name, issue_comments.issue_id, COUNT(issue_comments.comment_id)
      FROM issue_comments
      JOIN issues ON issues.id = issue_comments.issue_id
      JOIN projects ON projects.id = issues.repo_id
      GROUP BY issue_comments.issue_id

Anna Buhman, Christian Cmehil-Warn