0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

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

fork query

edited sep 25

created sep 25 anonymous