Who does the most typing on Stack Overflow?

2

Please login or register to vote for this query.

(click on this box to dismiss)

Displays the 10 chattiest of our peers...

MathOverflow

Q&A for professional mathematicians

-- Who does the most typing on Stack Overflow?
-- Displays the 10 chattiest of our peers...

select top 10 u.Id as [User Link], 
 (select sum(len(Body)) from posts where owneruserid = u.id) posts,
 (select sum(len(Text)) from comments where userid = u.id) comments,
 (select sum(len(Body)) from posts where owneruserid = u.id) +
 (select sum(len(Text)) from comments where userid = u.id) total

from users u 
order by total desc

--select top 10 u.Id as [User Link], 
--sum(len(p.Body)) as AnswerKeystrokes,
--sum(len(c.Text))as CommentKeystrokes
--from users u 
--    inner join posts p on u.id=p.owneruserid
--    inner join comments c on u.id = c.userid
--group by u.id
--order by AnswerKeystrokes desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached