Get average answer score by user

0

Please login or register to vote for this query.

(click on this box to dismiss)

3D Printing Meta

Q&A for 3D printing enthusiasts

SELECT top 100 p.OwnerUserId, u.displayname, 
AVG(CAST(Score as float)) AS VOTE,
count(p.id)
FROM Posts p inner join users u on p.owneruserid = u.id
WHERE p.PostTypeId = 2
group by p.owneruserid, u.displayname
having count(p.id) > 50
order by 3 desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results