0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

SELECT users.id, users.Reputation, posts.PostTypeId
FROM Users
JOIN Posts ON Posts.OwnerUserId = Users.id
--WHERE users.id NOT IN (
    --SELECT OwnerUserId
    --FROM Posts
  --  WHERE PostTypeId = 2
--)
    WHERE users.id IN (
    SELECT OwnerUserId
    FROM Posts
    WHERE PostTypeId !=  2
    GROUP BY OwnerUserId
 --   HAVING COUNT(PostTypeId) >= 10
);

fork query

edited dec 6

created dec 6 anonymous