0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and researchers interested in open data

SELECT YEAR(CreationDate) AS CreationYear, COUNT(*) AS UserCount
FROM Users
WHERE CreationDate >= DATEADD(YEAR, -10, GETDATE())
GROUP BY YEAR(CreationDate)
ORDER BY CreationYear DESC;

fork query

created dec 7 anonymous