Answer per period X

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  DATEFROMPARTS(YEAR(p.CreationDate), MONTH(p.CreationDate), 1) AS [Month],
  COUNT(*) AS [Count]
FROM Posts p
  INNER JOIN Users u ON p.OwnerUserId = u.Id
WHERE u.Id = ##UserId:int?456814##
  AND p.PostTypeId = 2 -- answers
GROUP BY YEAR(p.CreationDate), MONTH(p.CreationDate)
ORDER BY [Month]

Enter Parameters

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