0

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 anime and manga fans

-- 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

fork query

created oct 26 11 The Blue Bomber