Average reputation for answering users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Constructed Languages Meta

Q&A about the site for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

SELECT AVG(reputation), stdev(reputation)
FROM (SELECT u.id as uid, COUNT(p.id) as nbAns
FROM Users as u
INNER JOIN Posts as p ON p.OwnerUserId = u.id
WHERE PostTypeId = 2
GROUP BY u.id) as countAns
INNER JOIN Users AS u on u.id = countAns.uid

Enter Parameters

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