Percentage of questions answered by time of asking

0

Please login or register to vote for this query.

(click on this box to dismiss)

TeX - LaTeX

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems

SELECT 
  DATEPART(HOUR,CreationDate) AS HOUR,
  COUNT(*) AS TOTAL, 
  COUNT(CASE WHEN AcceptedAnswerId IS NOT NULL THEN 1 END) AS ANSWERED,
  COUNT(CASE WHEN AcceptedAnswerId IS NOT NULL THEN 1 END) * 1.0/COUNT(*) AS PERCENTANSWERED
FROM Posts WHERE PostTypeId = 1 GROUP BY DATEPART(HOUR,CreationDate);

Enter Parameters

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