Shows the fraction of all questions answered by the most prolific answerers.
Q&A for linguists, teachers, students and Spanish language enthusiasts in general wanting to discuss the finer points of the language
-- Percent of questions answered by the top users.
-- Shows the fraction of all questions answered by the most prolific answerers.
declare @QuestionCount float
select @QuestionCount = count(Id) from Posts where PostTypeId = 1
OwnerUserID As [User Link],
count(Id) aS AnswerCount,
100 * count(Id) / @QuestionCount as PercentQuestionsAnswered
PostTypeId = 2 -- Answer
and CommunityOwnedDate is null
(100 * count(Id) / @QuestionCount) >= ##MinimumPercentQuestionsAnswered##
order by AnswerCount desc