Unanswered Question Count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things

Q&A for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT count(*) AS unanswered, MONTH(Posts.CreationDate) AS month, YEAR(Posts.CreationDate) AS year FROM Posts 
WHERE Posts.AnswerCount = 0
GROUP BY YEAR(Posts.CreationDate),MONTH(Posts.CreationDate)
ORDER BY YEAR(Posts.CreationDate) DESC, MONTH(Posts.CreationDate) ASC, unanswered

Enter Parameters

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