8

Please login or register to vote for this query.

(click on this box to dismiss)

For each site, show the average number of votes per post (questions and answers alike)

Q&A for pro webmasters

SELECT
    Count(*) * 1.0 / (SELECT Count(*) FROM Posts WHERE PostTypeId = 1 OR PostTypeId = 2) AS [Votes],
    Count(CASE VoteTypeID WHEN 2 THEN 1 END) * 1.0 / (SELECT Count(*) FROM Posts WHERE PostTypeId = 1 OR PostTypeId = 2) AS [Upvotes],
    Count(CASE VoteTypeID WHEN 3 THEN 1 END) * 1.0 / (SELECT Count(*) FROM Posts WHERE PostTypeId = 1 OR PostTypeId = 2) AS [Downvotes]
  FROM Votes
  WHERE (VoteTypeId = 2 OR VoteTypeId = 3)

view current version

edited aug 30 12

created aug 30 12 Gilles