User Answer Count Rank

0

Please login or register to vote for this query.

(click on this box to dismiss)

Health Meta

Q&A about the site for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences

WITH RankedUsers As (
  SELECT OwnerUserId,
         COUNT(*) AS AnswerCount,
         ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC) AS Rank
  FROM Posts
  WHERE PostTypeId=2
    AND OwnerUserId IS NOT NULL
  GROUP BY OwnerUserId
)
SELECT Rank,
       OwnerUserId AS [User Link],
       AnswerCount
FROM RankedUsers
WHERE Rank < 100
   OR OwnerUserId = ##UserId##
ORDER BY Rank

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results