Minimum, Maximum, and Average Number of Answers Per Post

Please login or register to vote for this query.

(click on this box to dismiss)

The minimum, maximum, and average number of answers per post on Stack Overflow.

Q&A for programmers

-- Minimum, Maximum, and Average Number of Answers Per Post
-- The minimum, maximum, and average number of answers per post on Stack Overflow.

select
  min(Posts.AnswerCount) as [Minimum # of Answers],
  avg(cast(Posts.AnswerCount as decimal)) as [Average # of Answers],
  max(Posts.AnswerCount) as [Maximum # of Answers]
from Posts
where Posts.PostTypeId=1

created oct 26 11