Q&A for pro webmasters
-- Enter Query Title -- Enter Query Description with upvoted as ( select posts.Id as PostId from posts inner join votes on posts.Id = votes.PostId where votes.VoteTypeId = 2 -- upvotes and posts.PostTypeId = 2 -- answers group by posts.Id ) select users.Id, count(posts.Id) as [Posts], count(upvoted.PostId) as [Upvoted Posts], count(upvoted.PostId) * 100.0 / count(posts.Id) as [Upvoted %] from users left outer join posts on users.Id = posts.OwnerUserId left outer join upvoted on posts.Id = upvoted.PostId where posts.PostTypeId = 2 group by users.Id having count(posts.Id) >= 5 --order by [Upvoted %] desc;