Question and answer counts vs reputation

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT
  LOG(Users.Reputation,10),
  LOG(CONVERT(DECIMAL(10,1),COUNT(DISTINCT questions.Id))/CONVERT(DECIMAL(10,1),COUNT(DISTINCT answers.Id)),10) AS QuestionsPerAnswer
FROM
  Users
INNER JOIN
  Posts questions
  ON Users.Id = questions.OwnerUserId AND questions.PostTypeId = 1
INNER JOIN
  Posts answers
  ON Users.Id = answers.OwnerUserId AND answers.PostTypeId = 2
GROUP BY 
  Users.Id, Users.Reputation
ORDER BY
  Users.Reputation DESC

Enter Parameters

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