0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT 2019 as year, count(*) as new_users from Users WHERE YEAR(CreationDate) = 2019
union 
SELECT 2018, count(*) from Users WHERE YEAR(CreationDate) = 2018
union 
SELECT 2017, count(*) from Users WHERE YEAR(CreationDate) = 2017
union 
SELECT 2016, count(*) from Users WHERE YEAR(CreationDate) = 2016
union 
SELECT 2015, count(*) from Users WHERE YEAR(CreationDate) = 2015
union 
SELECT 2014, count(*) from Users WHERE YEAR(CreationDate) = 2014
union 
SELECT 2013, count(*) from Users WHERE YEAR(CreationDate) = 2013
union
SELECT 2012, count(*) from Users WHERE YEAR(CreationDate) = 2012
union
SELECT 2011, count(*) from Users WHERE YEAR(CreationDate) = 2011
union
SELECT 2010, count(*) from Users WHERE YEAR(CreationDate) = 2010
union
SELECT 2009, count(*) from Users WHERE YEAR(CreationDate) = 2009

fork query

edited jul 19

created jul 19 anonymous