0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for those who base their lives on Jewish law and tradition and anyone interested in learning more

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

fork query

edited dec 12

created dec 12 anonymous