Most Accepted Users


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Most Accepted Users
Declare @minAnswers int = ##MinAnswers##
select Accepted,Answered,cast(10000*Accepted/Answered as float)/100 as pct,
UserID as [User Link] from
(select count( as "Answered", count(iif(,,null)) as "Accepted", as "UserID", u.DisplayName as DisplayName --
from Posts a, Users u, Posts q --
where a.OwnerUserId = and q.PostTypeId = 1 and
a.PostTypeId = 2 and group by,u.Displayname) t --
where answered >= @minAnswers order by pct desc

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results