1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

-- Minimum number of answers a user must have written to be included.
DECLARE @MinAnswers int = ##MinAnswers##

SELECT
       TOP 100
       Users.Id AS [User Link],
       SUM(Posts.Score) AS "Upvotes earned",
       COUNT(*) AS "Answers written",
       1.0 * SUM(Posts.Score) / COUNT(*) AS "Average answer score"
FROM Posts LEFT JOIN Users
ON Posts.OwnerUserId = Users.Id
WHERE Posts.PostTypeId = 2
GROUP BY Users.Id
HAVING COUNT(*) >= @MinAnswers
ORDER BY "Average answer score" DESC

view current version

edited sep 5 15

created sep 5 15 DanielSank