0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

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

fork query

edited jul 19

created jul 19 anonymous