0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who like playing board games, designing board games or modifying the rules of existing board games

SELECT COUNT(*) AS UserCount
FROM Users u
WHERE u.Id IN (
    SELECT DISTINCT OwnerUserId
    FROM Posts
    WHERE PostTypeId = 2 -- Find users who posted answers
    GROUP BY OwnerUserId
    HAVING COUNT(*) > 10 -- More than 10 answers
)
AND u.Id NOT IN (
    SELECT DISTINCT OwnerUserId
    FROM Posts
    WHERE PostTypeId = 1 -- Find users who posted questions
);

view current version

edited dec 5

created dec 5 anonymous