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 select OwnerUserID As [User Link], OwnerUserID, count(Id) aS AnswerCount, 100 * count(Id) / @QuestionCount as PercentQuestionsAnswered from Posts where PostTypeId = 2 -- Answer and CommunityOwnedDate is null group by OwnerUserId having (100 * count(Id) / @QuestionCount) >= 1 order by AnswerCount desc