0

Please login or register to vote for this query.

(click on this box to dismiss)

Who are the top answerers for a given tag?

Q&A for scientific skepticism

-- Tag Leaderboard for Answers
-- Who are the top answerers for a given tag?

DECLARE @TagName NVARCHAR(25) = '##TagName##';
DECLARE @MinimumScore INT = ##MinimumScore##;

SELECT
    ROW_NUMBER() OVER(ORDER BY SUM(a.Score) DESC) AS [#], 
    a.OwnerUserId AS [User Link], 
    SUM(a.Score) AS [Total Score]
FROM
    Posts a, 
    Posts q
INNER JOIN
    PostTags qt
    ON q.Id = qt.PostId
INNER JOIN
    Tags t
    ON t.Id = qt.TagId
WHERE
    a.ParentId = q.Id
    AND a.PostTypeId = 2
    AND a.CommunityOwnedDate IS NOT NULL
    AND t.TagName = @TagName
GROUP BY
    a.OwnerUserId
    HAVING SUM(a.Score) >= @MinimumScore;

fork query

created sep 30 10 BoltClock