Number of Posts per User

0

Please login or register to vote for this query.

(click on this box to dismiss)

This is a query that returns the number of posts per user in descending order

Computational Science

Q&A for scientists using computers to solve scientific problems

-- Number of Posts per User
-- This is a query that returns the number of posts per user in descending order

SELECT  Posts as 'Number of Posts', log(Count(*))/log(10) AS 'log10(Number of users)' FROM(
 SELECT Count(*) AS Posts, OwnerDisplayName AS 'Post Owner' FROM Posts
 WHERE OwnerUserId IN
 (SELECT Id FROM Users)
 GROUP BY OwnerDisplayName
) AS x
GROUP BY Posts
HAVING Posts<100
ORDER BY Posts ASC

Enter Parameters

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