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 = 1 AND PostTypeId <> 2
 --   GROUP BY OwnerUserId
 --   HAVING COUNT(PostTypeId) >= 10
--);
where users.id = 2028066

fork query

edited dec 6

created dec 6 anonymous