0

Please login or register to vote for this query.

(click on this box to dismiss)

How many questions per month does each tag in the top 10 tags get

Q&A for anime and manga fans

SELECT
  [Data].[Month],
  COUNT(*)
FROM
(
  SELECT
    CAST(CAST(DATEPART(YYYY, CreationDate) AS varchar(max)) + '-' + CAST(DATEPART(MM, CreationDate) AS varchar(max)) + '-01' AS datetime) AS [Month]
  FROM [Posts]
) AS [Data]
GROUP BY
  [Data].[Month]
ORDER BY
  [Data].[Month]

fork query

edited jan 26 12 anonymous

created jan 16 12 sam.saffron