Average accept-rate, users with greater then 200 reputation.


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

with ByUser as (
 select OwnerUserId
      , cast(count(AcceptedAnswerId) as float) 
        / cast(count(*) as float) as AcceptRate
   from posts p
   join users u
     on p.OwnerUserId = u.id
  where u.Reputation > 200
    and p.PostTypeId = 1
    and CommunityOwnedDate is null
  group by OwnerUserId
 having count(*) >= 4
 select avg(AcceptRate) as AverageAcceptRate
   from ByUser

Enter Parameters

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