Question-Score-to-Answer Ratio

0

Please login or register to vote for this query.

(click on this box to dismiss)

Count of all questions, sum of question scores, compared to count of answers. Used to see how statistically likely a question is to receive votes or answers. Basically, this is how good a community is at up-voting questions.

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

-- Question-Score-to-Answer Ratio
-- Count of all questions, sum of question scores, compared to count of answers.
-- Used to see how statistically likely a question is to receive votes or answers.
--
-- Basically, this is how good a community is at up-voting questions.

SELECT
  COUNT(*) as Questions,
  SUM(Score) as QuestionScores,
  SUM(AnswerCount) as Answers,
  ROUND(CAST(SUM(Score) AS FLOAT)/SUM(AnswerCount), 3) AS Ratio
FROM
  Posts
WHERE 
  PostTypeId=1

Enter Parameters

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