Average reputation per post by user

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematica

Q&A for users of Wolfram Mathematica

SELECT U.Id [User Link], U.Reputation, R.postcount, U.Reputation/R.postcount AvgRep FROM Users U JOIN
( SELECT OwnerUserId user_id, COUNT(Id) postcount FROM Posts GROUP BY OwnerUserId ) R ON R.user_id =
U.Id

WHERE U.Reputation > 3000
ORDER BY AvgRep Desc

Enter Parameters

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