Questions by unlinked Answerers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows count and date range of answers and percentage of questions answered by OwnerDisplayName where OwnerUserID is null

Spanish Language

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],
  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) >= ##MinimumPercentQuestionsAnswered##
order by AnswerCount desc 

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results