0

Please login or register to vote for this query.

(click on this box to dismiss)

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

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 between 500 and 400
Group By 
    u.Id, u.Reputation 

Order By rate Asc

fork query

created jan 4 11 anonymous