Average reputation and posts per user, broken down by user's quintile of activity

1

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

SELECT Users.Id AS [User Link],
       PostTypeId,
       COUNT(PostTypeId)
    FROM Users
        JOIN Posts
            ON Posts.OwnerUserId = Users.Id
    GROUP BY Users.Id, PostTypeId

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results