Users with most answers


Please login or register to vote for this query.

(click on this box to dismiss)

Just a lsit of suers which wrote the most answers

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

-- Users with most answers
-- Just a list of users who wrote the most answers

SELECT TOP ##NumberOfUsers## s.userId as [User Link], u.DisplayName, s.answerCount, u.Reputation, u.Reputation / s.answerCount as peransweravg
SELECT u.Id AS userId, COUNT(p.Id) AS answerCount
FROM Users AS u JOIN Posts AS p ON u.Id=p.OwnerUserId
WHERE p.PostTypeId = 2
) AS s
JOIN Users AS u ON s.userId=u.Id
ORDER BY s.answerCount DESC

Enter Parameters

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