0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

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

fork query

edited dec 12

created dec 12 anonymous