Questions answered by more than 3 "Top N" users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Thanks to https://codereview.stackexchange.com/a/244191/103675 for the improvements!

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Q.Id AS [Post Link], Q.AnswerCount
FROM Posts Q
WHERE Q.AnswerCount >= 3
AND
(
  SELECT COUNT( DISTINCT A.OwnerUserId)
  FROM Posts A
  WHERE A.ParentId = Q.Id
  AND A.OwnerUserId IN
  (
    SELECT TOP ##TopN## Id
    FROM Users
    ORDER BY Reputation DESC
  )
) = 3

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results