Who does the most typing on Stack Overflow?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Displays the 100 chattiest of our peers...

SharePoint

Q&A for SharePoint enthusiasts

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


select top 100 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 100 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 to meta site
loading Hold tight while we fetch your results