SELECT u.DisplayName FROM Users u INNER JOIN Posts resp O...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Esperanto Language

Q&A for teachers and students of the Esperanto language

SELECT u.DisplayName
FROM Users u INNER JOIN Posts resp
 ON u.Id = resp.OwnerUserId
 INNER JOIN Posts preg ON resp.ParentId = preg.Id
 INNER JOIN PostTags pt ON pt.PostId = preg.Id
 INNER JOIN Tags t ON t.Id = pt.TagId
WHERE t.TagName = 'c#'
GROUP BY u.Id, u.DisplayName
ORDER BY SUM(resp.Score) DESC
OFFSET 0 ROWS FETCH FIRST 10 ROWS ONLY;

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results