Questions counted by number of answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Astronomy

Q&A for astronomers and astrophysicists

SELECT LOG(AnswerCount, 10), LOG(COUNT(*), 10)
  FROM Posts
  WHERE PostTypeId = 1 -- questions
    AND AnswerCount > 0 -- answered questions only
  GROUP BY AnswerCount
  ORDER BY AnswerCount

Enter Parameters

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