Keystrokes per rep point

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ranks users with over 5000 reputation points by how many characters they needed to type to achieve that reputation (counts title and body characters)

Game Development Meta

Q&A about the site for professional and independent game developers

-- Keystrokes per rep point
-- Ranks users with over 5000 reputation points by how many characters they needed to type to achieve that reputation (counts title and body characters)

Select u.Id As [User Link], 
   (sum(coalesce(datalength(p.Body),0)) + sum(coalesce(datalength(p.Title),0))) As keystrokes, 
   u.Reputation, 
   (sum(coalesce(datalength(p.Body),0)) + sum(coalesce(datalength(p.Title),0)))/u.Reputation As rate 
From users u, posts p 
Where p.OwnerUserId = u.Id And u.Reputation >= 4500 AND u.Reputation <= 5000
Group By u.Id, u.Reputation
Order By rate Asc

Enter Parameters

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