Does not count self-answers. Shows users with at least @MinAnswers answers.
Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
-- Average accept rate of answers -- Except for Jon Skeet, Darin Dimitrov, BalusC, etc SELECT 200*(answer_count/200) answer_count, 100*sum(accepted_answer_count)/sum(answer_count) accepted_percent FROM ( SELECT users.Id, count(*) answer_count, sum(case when questions.AcceptedAnswerId = answers.Id then 1 else 0 end) accepted_answer_count FROM Posts answers INNER JOIN Users users ON users.Id = answers.OwnerUserId INNER JOIN Posts questions ON answers.ParentId = questions.Id WHERE (questions.OwnerUserId <> users.Id OR questions.OwnerUserId IS NULL) --no self answers GROUP BY users.Id HAVING count(*) < 10000 ) X GROUP BY answer_count/200