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

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

-- 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', Count(*) AS 'Number of users' FROM(
 SELECT Count(*) AS Posts, OwnerDisplayName AS 'Post Owner' FROM Posts
 WHERE OwnerUserId IN
 (SELECT Id FROM Users) and PostTypeId = 1
 GROUP BY OwnerDisplayName
) AS x
GROUP BY Posts
ORDER BY Posts ASC

Enter Parameters

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