0

Please login or register to vote for this query.

(click on this box to dismiss)

This query finds the 100 users with the lowest average score per post, given they have at least two posts.

Q&A for SharePoint enthusiasts

-- Bottom 100 Scorers
-- This query finds the 100 users with the lowest average score per post, given
-- they have at least two posts.

SELECT TOP 100
  OwnerUserId AS [User Link],
  COUNT(*) AS NumPosts,
  CAST(AVG(CAST(Score AS float)) as numeric(6,2)) AS Score
FROM Posts
GROUP BY OwnerDisplayName, OwnerUserID
HAVING COUNT(*) > 1
ORDER BY Score ASC

fork query

created sep 28 11 brad.cavanagh