answers per user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select TOP 10 Users.DisplayName, Users.Reputation, count(*) as answers
from Posts
join Users on (Users.Id = Posts.OwnerUserId)
where PostTypeId = 2 and OwnerUSerId > 0
group by OwnerUserId, Users.DisplayName, Users.Reputation
order by answers desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results