0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and independent game developers

select 
(SELECT count(*) from Users) as total,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2018' AND '12/31/2019' ) as _2019,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2017' AND '12/31/2018' ) as _2018,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2016' AND '12/31/2017' ) as _2017,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2015' AND '12/31/2016' ) as _2016,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2014' AND '12/31/2015' ) as _2015,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2013' AND '12/31/2014' ) as _2014,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2012' AND '12/31/2013' ) as _2013,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2011' AND '12/31/2012' ) as _2012,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2010' AND '12/31/2011' ) as _2011,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2009' AND '12/31/2010' ) as _2010,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2008' AND '12/31/2009' ) as _2009
;

fork query

edited jul 19 19

created jul 19 19 anonymous