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],
    P.C AS Count
FROM Users U
INNER JOIN
    (SELECT
    OwnerUserId, C = Count(*)
    FROM Posts
    WHERE Score >= 10
    GROUP BY OwnerUserId) P
ON U.id = P.OwnerUserId
ORDER BY P.C Desc

fork query

created sep 7 10 Peter Ajtai