1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

SELECT
  ROW_NUMBER() OVER(ORDER BY SUM(a.Score) DESC) AS [Rank],
  u.Id AS [User Link],
  u.DisplayName,
  u.Location,
  SUM(a.Score) AS [Total Score],
  COUNT(a.Id) AS [Answer Count]
FROM
  Users u
  INNER JOIN Posts a ON a.OwnerUserId = u.Id
  INNER JOIN Posts q ON q.Id = a.ParentId
  INNER JOIN PostTags pt ON pt.PostId = q.Id
  INNER JOIN Tags t ON t.Id = pt.TagId
WHERE
  t.TagName = 'xamarin' -- specify your tag name here
  AND u.Location LIKE 'Ukraine' -- specify your location here
  AND a.PostTypeId = 2 -- answers
GROUP BY
  u.Id,
  u.DisplayName,
  u.Location
ORDER BY
  [Total Score] DESC;

fork query

edited mar 31

created mar 31 Denis.Dinkevich