instruction: Questions per month, Scala Web Frameworks. How do Scala web frameworks compare to each other?
  
  I'm restricting the questions to those tagged Scala, to avoid polluting Playframework's result. It might be unfair, but I can't think of any other way to do it. At least all frameworks are being equally discriminated against.
response: SELECT *, COUNT(*) AS "Count" FROM (SELECT DATE(CAST(TIME_TO_STR(CreationDate, '%Y') AS TEXT) + '-' + CAST(TIME_TO_STR(CreationDate, '%m') AS TEXT) + '-01') AS Month, t.TagName FROM (SELECT p.Id, p.CreationDate FROM Posts AS p JOIN PostTags AS pt ON pt.PostId = p.Id JOIN Tags AS t ON t.Id = pt.TagId WHERE t.TagName = 'scala') AS pp JOIN PostTags AS pt ON pt.PostId = pp.Id JOIN Tags AS t ON t.Id = pt.TagId WHERE t.TagName IN ('playframework', 'playframework-1.x', 'playframework-2.0', 'playframework-2.x', 'lift', 'liftweb', 'scalatra', 'vaadin', 'finagle', 'scalate', 'pinky', 'xitrum', 'blueeyes', 'circumflex', 'bowler', 'scala')) AS X GROUP BY TagName, Month ORDER BY Month DESC, Count