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 Count(*) AS 'Number of users', Posts as 'Number of Posts' 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 to meta site
loading Hold tight while we fetch your results