0

Please login or register to vote for this query.

(click on this box to dismiss)

Returns the top 100 users by number of questions asked.

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT TOP 100
    OwnerUserId AS [User Link],
    COUNT(*) as [Number of Questions]
FROM Posts
WHERE
    PostTypeID = 1 AND
    OwnerUserId >= 0
GROUP BY OwnerUserId
ORDER BY [Number of Questions] DESC

fork query

created aug 22 11 Jeremy Banks