0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for finance professionals and academics

SELECT 
    U.Id AS UserId,
    U.Reputation
FROM Users U
WHERE 
    U.Id IN (
        SELECT OwnerUserId
        FROM Posts
        WHERE PostTypeId = 2
        GROUP BY OwnerUserId
        HAVING COUNT(*) > 10
    )
    AND U.Id NOT IN (
        SELECT OwnerUserId
        FROM Posts
        WHERE PostTypeId = 1
    )
ORDER BY U.Reputation DESC;

fork query

edited dec 6

created dec 6 jon.doe46505