Questions counted by number of answers (full)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Astronomy

Q&A for astronomers and astrophysicists

SELECT AnswerCount AS 'Number of answers', COUNT(*) AS 'Frequency'
  FROM Posts
  WHERE PostTypeId = 1 -- questions
  GROUP BY AnswerCount
  ORDER BY AnswerCount

Enter Parameters

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