Q&A about the site for information security professionals
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 avg(AcceptRate) as AverageAcceptRate from ByUser