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

DECLARE @TsNow DATETIME;

SELECT @TsNow = DATEFROMPARTS(
    DATEPART(yyyy, MAX(CreationDate)),
    DATEPART(mm, MAX(CreationDate)),
    1) FROM Posts;

SELECT
  DATEFROMPARTS(
    DATEPART(yyyy, CreationDate),
    DATEPART(mm, CreationDate),
    1) AS Month,
  COUNT(*) AS Count
FROM Users
WHERE CreationDate < @TsNow
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