0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description
SELECT TOP 100
    Id AS [User Link],
    Reputation,
    P.Cnt AS Answers
FROM Users U
    INNER JOIN (
        SELECT OwnerUserId, Cnt = Count(*)
        FROM Posts
        WHERE PostTypeId > 1
        GROUP BY OwnerUserId
        HAVING Count(*) >= ##MinNumberOfPosts##
    ) P ON U.Id = P.OwnerUserId
ORDER BY Reputation DESC

fork query

created sep 6 10 Peter Ajtai