1

Please login or register to vote for this query.

(click on this box to dismiss)

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

view current version

edited feb 17 13

created feb 16 13 robjohn