Answer per period X


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

  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

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