Q&A about the site for Tridion developers and administrators
SELECT ROW_NUMBER() OVER(ORDER BY SUM(p.score) DESC) AS [#], p.OwnerUserId AS [User Link], Max(u.Reputation) as [Total Reputation], SUM(p.score) as [Tag Repuation] FROM Users u JOIN Posts p ON p.OwnerUserId = u.Id INNER JOIN Posts q on q.id = p.parentid WHERE p.posttypeid = 2 -- just answers AND q.tags like LOWER('%<##TagName##>%') GROUP BY p.OwnerUserId ORDER BY sum(p.score) DESC