0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

SELECT TOP 50 
  Users.DisplayName, 
  SUM(Posts.Score) AS TotalVotes,
  COUNT(Posts.Id) AS QuestionCount
FROM 
  Posts
JOIN 
  Users ON Posts.OwnerUserId = Users.Id
WHERE 
  Posts.PostTypeId = 1 -- PostTypeId = 1 refers to Questions
GROUP BY 
  Users.DisplayName
ORDER BY 
  TotalVotes DESC

fork query

edited oct 21

created oct 21 Yaroslav.Bulatov