Q&A for professional and enthusiast programmers
SELECT Distinct u.Id AS [User Link], CONCAT('https://stackoverflow.com/users/', u.Id) AS [Profile Link], u.DisplayName, 'Tag:'+t.TagName, SUM(a.Score) as [Tag Score], COUNT(*) as [Answer count] FROM Users u INNER JOIN Posts a ON a.OwnerUserId = u.id INNER JOIN Posts q ON a.ParentId = q.Id INNER JOIN PostTags pt ON pt.PostId = q.Id INNER JOIN Tags t ON t.Id = pt.TagId WHERE a.CommunityOwnedDate IS NULL AND -- CW post don't count towards a tag score Upper(t.TagName) Like Upper('%##TagName##%') AND Upper(u.Location) LIKE Upper('%##Location##%') AND Upper(t.TagName) NOT LIKE Upper('%##ExcludeTag##%') GROUP BY u.id, u.DisplayName, t.TagName Having SUM(a.Score) > COUNT(*) ORDER BY SUM(a.Score) DESC