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

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

-- 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 main site
loading Hold tight while we fetch your results