Percent of questions answered by the top users.

0

Please login or register to vote for this query.

(click on this box to dismiss)

Shows the fraction of all questions answered by the most prolific answerers.

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

-- 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 

Enter Parameters

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