select (SELECT count(*) from Users) as total, (SELECT cou...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

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,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2007' AND '12/31/2008' ) as _2008,
(SELECT count(*) from Users WHERE CreationDate BETWEEN '12/31/2006' AND '12/31/2007' ) as _2007

Enter Parameters

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