questions per month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

SELECT 
  DATEPART(YEAR, CreationDate) AS Year,
  DATEPART(MONTH, CreationDate) AS Month,
  COUNT(*) AS QuestionCount
FROM 
  Posts
WHERE 
  PostTypeId = 1 -- 1 represents questions
  AND CreationDate >= '2022-01-01'
  AND CreationDate < '2025-01-01'
GROUP BY 
  DATEPART(YEAR, CreationDate),
  DATEPART(MONTH, CreationDate)
ORDER BY 
  QuestionCount

Enter Parameters

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