SELECT u.DisplayName, u.Reputation, COUNT(ans.Id) as Answ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT u.DisplayName, u.Reputation, COUNT(ans.Id) as AnswerCount
FROM Posts ans
INNER JOIN Posts p ON p.Id = ans.ParentId
INNER JOIN Users u ON ans.OwnerUserId = u.Id
INNER JOIN PostTags pt ON pt.PostId = p.Id
INNER JOIN Tags t ON t.Id = pt.TagId
WHERE ans.PostTypeId = 2
  AND t.TagName in ('prism', 'prism-2', 'prism-4')
GROUP BY u.DisplayName, u.Reputation, ans.Id
ORDER BY COUNT(ans.Id) DESC, u.Reputation DESC

Enter Parameters

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