axon answers count

1

Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

--DECLARE @TagId int = ##TagId##

SELECT OwnerUserId, DisplayName, COUNT(OwnerUserId) as NumAnswers FROM Posts
  INNER JOIN Users ON Users.Id = OwnerUserId
WHERE Posts.Id IN (
  SELECT Posts.AcceptedAnswerId
  FROM
    Posts
    INNER JOIN PostTags ON Posts.Id = PostTags.PostId
    INNER JOIN Tags ON PostTags.TagId = Tags.Id
  WHERE 
  TagId = '83655' -- [axon] tag
  --TagId = @TagId
)
GROUP BY OwnerUserId, DisplayName
ORDER BY NumAnswers DESC

Enter Parameters

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