0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

with totals as (
 select OwnerUserId
      , cast(count(AcceptedAnswerId) as float) / cast(count(*) as float) as Accepted
   from posts p
   join users u
     on p.OwnerUserId = u.id
  where u.Reputation > 200
    and p.PostTypeId = 1
  group by OwnerUserId
        )
        select avg(Accepted)
  from totals

view current version

edited jun 9 12

created jun 9 12 Ben