Minimum, Maximum, and Average Number of Answers Per Post

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.

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached