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