0

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 COUNT(a.Id) DESC) AS [Rank],
  u.Id AS [User Link],
  u.DisplayName,
  u.Location,
  COUNT(a.Id) AS [Answer Count],
  SUM(a.Score) AS [Total Score]
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 = 'wpf' -- 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
  [Answer Count] DESC;

fork query

edited mar 31

created mar 31 Denis.Dinkevich