0

Please login or register to vote for this query.

(click on this box to dismiss)

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
  where p.PostTypeId = 1
    and CommunityOwnedDate is null
    and exists ( select 1 
                   from posts
                  where ParentId = p.Id )
  group by OwnerUserId
 having count(*) >= 4
        )
 , FirstStep as ( 
 select AcceptRate
      , row_number() over ( order by AcceptRate asc ) as RowAsc
      , row_number() over ( order by AcceptRate desc ) as RowDesc
   from ByUser )
select avg(AcceptRate)
  from FirstStep
where RowAsc in (RowDesc, RowDesc - 1, RowDesc + 1)

fork query

edited jun 9 12

created jun 9 12 Ben