Q&A for professional and enthusiast programmers
SELECT *, COUNT(*) FROM ( SELECT cast (DATEPART(YYYY, Users.CreationDate) as int)[YEAR] FROM Users ) AS t where [YEAR] < year(getdate()) GROUP BY [YEAR] ORDER BY [YEAR] ASC