0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

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

fork query

edited dec 13

created dec 13 anonymous