0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select (
  select SUM(p.score * p.PostTypeId * 5)
  from Posts p
  where p.OwnerUserId = u.Id
) as computed_rep, u.Reputation as real_rep, u.DisplayName as alias
from Users u order by computed_rep desc

fork query

edited jun 28 13

created mar 17 13 anonymous