Average quality of answers by users


Please login or register to vote for this query.

(click on this box to dismiss)

Average votes of answers for users with at least MinAnswers answers

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

-- Average number of votes per question

  Count(*) AS [Votes],
  Count(CASE v.VoteTypeID WHEN 2 THEN 1 END) AS [Upvotes],
  Count(CASE v.VoteTypeID WHEN 3 THEN 1 END) AS [Downvotes]
from votes v
join posts p on v.postid=p.id
  p.posttypeid = 1 and
  p.closeddate is null and 
    DATEPART(YYYY, p.creationdate) > ##YYYY##  or 
      DATEPART(YYYY, p.creationdate) = ##YYYY## and 
      DATEPART(MM, p.creationdate) >= ##MM##
  ) and
    v.VoteTypeId = 2 or
    v.VoteTypeId = 3

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results