Comment Score distribution


Please login or register to vote for this query.

(click on this box to dismiss)

How many comments do I have for each score.

Stack Overflow

Q&A for professional and enthusiast programmers

  t.cnt as total,
  COUNT(*) comment_count,
  ROUND(COUNT(*) / CAST(t.cnt AS FLOAT) * 100.0, 2) as percentage
FROM comments
  JOIN (SELECT COUNT(1) AS cnt FROM comments) t
WHERE score >= 10
GROUP BY t.cnt

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results