0

Please login or register to vote for this query.

(click on this box to dismiss)

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

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

-- 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 >= 1000 
Group By u.Id, u.Reputation
Order By rate Asc

fork query

created nov 19 10 badp