Keystrokes per rep point, mod. for user defined rep cutoff

1

Please login or register to vote for this query.

(click on this box to dismiss)

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

Japanese Language Meta

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

-- Keystrokes per rep point, mod. for user defined rep cutoff
-- Ranks users with over RepCutoff reputation points by how many characters they needed to type to achieve that reputation (counts title and body characters). Original by shog9.

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 >=##RepCutoff## 
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