0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

SELECT 
    YEAR(CreationDate) AS Year,
    COUNT(*) AS NumberOfUsers
FROM 
    users
WHERE 
    CreationDate >= DATEADD(YEAR, -10, GETDATE())
GROUP BY 
    YEAR(CreationDate)
ORDER BY 
    Year DESC;

fork query

edited dec 14

created dec 14 anonymous