Total reputation against number of questions per user

0

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

select
  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

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