Top 10 question askers in Meta Stack Exchange

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

SELECT TOP 10  
       ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) AS [Row Number],
       OwnerUserId AS [User Link], 
       COUNT(PostTypeId) AS [Questions Count]
FROM Posts
WHERE OwnerUserId IS NOT NULL AND OwnerUserId <> -1
      AND PostTypeId = 1 -- Questions
GROUP BY OwnerUserId
ORDER BY COUNT(PostTypeId) DESC;

Enter Parameters

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