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
FROM Posts p inner join users u on p.owneruserid = u.id
WHERE p.PostTypeId = 2
group by p.owneruserid, u.displayname
order by 2 desc

Enter Parameters

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