select year(Users.CreationDate) as "Year", count(Users.Di...


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 year(Users.CreationDate) as "Year", count(Users.DisplayName) as "Total"
from Users
where Users.CreationDate >= '2010-01-01' AND Users.CreationDate <= '2019-12-31'
Group by  year(Users.CreationDate)

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results