instruction: Top N answerers for a given tag.
response: SELECT TOP(100) AS TagName, SUM(CASE Votes.VoteTypeId WHEN 2 THEN 1 WHEN 3 THEN -1 END) AS Rep, Users.Id AS "user_link", number = ROW_NUMBER() OVER (ORDER BY TagName) FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId INNER JOIN Users ON Posts.OwnerUserId = Users.Id INNER JOIN Votes ON Votes.PostId = Posts.Id WHERE Tags.TagName = @tagName AND Posts.CommunityOwnedDate IS NULL AND Users.DisplayName LIKE '%##Name##%' GROUP BY TagName, Users.Id ORDER BY Rep DESC