Average quality of answers by users

4

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

Gardening and Landscaping

Q&A for gardeners and landscapers

-- Average number of votes per question

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

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