0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for user experience researchers and experts

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

fork query

edited aug 18 18 anonymous

created jan 13 15 Vlad Mihalcea