Q&A for scientists using computers to solve scientific problems
select top 300 t.Accepted,t.Answered,100*t.Accepted/t.Answered as pct, UserID, DisplayName from (select count(a.id) as "Answered", count(iif(a.id=q.acceptedAnswerId,a.id,null)) as "Accepted", u.id as "UserID", u.DisplayName as DisplayName -- from Posts a, Users u, Posts q -- where a.OwnerUserId = u.id and q.PostTypeId = 1 and a.PostTypeId = 2 and a.ParentId=q.id group by u.id,u.Displayname) t -- where t.Answered >= 10 order by pct desc