0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT u.Id,  u.DisplayName, SUM(rta.Score)
From Tags t INNER JOIN PostTags pt ON (t.Id = pt.TagId)
  INNER JOIN Posts p ON (p.Id = pt.PostId)
    INNER JOIN Posts rta ON (rta.ParentId = p.Id)
      INNER JOIN Users u ON (u.id = p.OwnerUserId)
-- Tags -> Posts Question -> Post Answers -> User of the Answer
WHERE p.ParentId IS NULL -- p es una pregunta
	AND t.TagName = 'c#'
GROUP BY u.Id, u.DisplayName
ORDER BY SUM(rta.Score) DESC
OFFSET 0 ROWS FETCH FIRST 10 ROWS ONLY

fork query

edited apr 18 Luis44376

created apr 16 anonymous