0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

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