Number of unanswered question (zero answers) per month

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

SELECT 
  eomonth(q.creationdate),
  COUNT(q.Id) AS Count
FROM Posts q
WHERE (q.PostTypeId=1) AND (q.AnswerCount=0)
GROUP BY eomonth(q.creationdate)
ORDER BY eomonth(q.creationdate)

Enter Parameters

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