SELECT 2019 as year, count(*) as new_users from Users WHE...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results