1

Please login or register to vote for this query.

(click on this box to dismiss)

Statistical summary of users who like to post long answers. Filters for users above a minimal post count.

Q&A about the site for people looking to bypass life's everyday problems with simple tricks

-- Users who post long answers
-- Statistical summary of users who like to post long answers.
-- Filters for users above a minimal post count.

SELECT TOP 2000
    Rank = Row_Number() OVER (ORDER BY avg(len(p.Body)) DESC),
    UserId = p.OwnerUserId,
    Username = Min(u.DisplayName),
    Total_Posts = Count(*),
    Average_Length_Of_Posts = avg(len(p.Body)),
    Total_Length_Of_Posts = sum(len(p.Body)),
    Longest_Post = max(len(p.Body)),
    Standard_Deviation_Of_Post_Lengths = stdev(len(p.Body)),
    Total_Rep = Min(u.Reputation),
    Rep_Per_Character = Min(Convert(float, u.Reputation)) / sum(len(p.Body))
FROM Posts p
INNER JOIN Users u ON
    u.Id = p.OwnerUserId
WHERE
    p.PostTypeId = 2
GROUP BY
    p.OwnerUserId
HAVING
    Count(*) >= ##MinimumPostCount##

fork query

created aug 1 10 Juliet