Accept rate by count, users greater than 200 reputation.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

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
  group by OwnerUserId
 having count(*) >= 4
        )
 select cast(100 * AcceptRate as int) as AcceptRate
      , count(*) as Count
   from ByUser
  group by cast(100 * AcceptRate as int)
  order by cast(100 * AcceptRate as int) asc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results