Total reputation against number of questions per user


Please login or register to vote for this query.

(click on this box to dismiss)

List of users with their total reputation now and the total number of non-deleted questions. Users who haven't asked any question are omitted.

Stack Overflow

Q&A for professional and enthusiast programmers

  u.Id as [User Link],
  max(u.Reputation) as [Reputation],
  Count(*) as [Questions],
  1.0 * max(u.Reputation) / Count(*) as [Rep/Q]
from Posts p
inner join Users u on u.Id = p.OwnerUserId
where p.PostTypeId = 1
group by u.Id
order by 1.0 * max(u.Reputation) / Count(*)

Enter Parameters

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