0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

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