Count of new user registrations by month

1

Please login or register to vote for this query.

(click on this box to dismiss)

It shows the stats only until the last completely dumped month to the SEDE.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  DATEFROMPARTS(
    DATEPART(yyyy, CreationDate),
    DATEPART(mm, CreationDate),
    1) AS Month,
  COUNT(*) AS Count
FROM Users
GROUP BY DATEFROMPARTS(
  DATEPART(yyyy, CreationDate),
  DATEPART(mm, CreationDate),
  1)
ORDER BY Month

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results