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)

スタック・オーバーフロー

プログラマーとプログラミングに熱心な人々のための質問と回答

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