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 Users.ID, Users.Reputation
FROM Users
JOIN Posts ON Users.ID = Posts.OwnerUserId
WHERE Posts.PostTypeID = 2 AND Users.ID NOT IN (
    SELECT OwnerUserID FROM Posts WHERE PostTypeID = 1
)
GROUP BY Users.ID, Users.Reputation
HAVING COUNT(*) > 10
ORDER BY Users.Reputation DESC;

view current version

edited dec 11

created dec 11 jon.doe46557