To whom do I answer on average?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT 
  COUNT(1) as nbe_answers,
  Questions.OwnerUserId as [User Link],
  AVG(Answers.Score) as A_score,
  AVG(Questions.Score) as Q_score
FROM
  Posts as Questions,
  Posts as Answers 
WHERE
  Questions.PostTypeId  = 1 AND
  Answers.PostTypeId  = 2 AND
  Answers.ParentId = Questions.Id AND
  Answers.OwnerUserId = ##UserId1## 
GROUP BY
  Questions.OwnerUserId
ORDER BY
  nbe_answers DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results