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

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

fork query

edited mar 20 13

created jan 14 11 anonymous