0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

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