1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

select TOP 10 Users.DisplayName, Users.Reputation, count(*) 
from Posts inner join Users on Posts.OwnerUserId = Users.Id
where PostTypeId = 1 
group by Users.DisplayName, Users.Reputation, OwnerUserId 
order by count(*) desc, Users.DisplayName, Users.Reputation;

fork query

edited jun 4 12

created jun 4 12 Gerrat