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 union SELECT 2011, count(*) from Users WHERE YEAR(CreationDate) = 2011 union SELECT 2010, count(*) from Users WHERE YEAR(CreationDate) = 2010 union SELECT 2009, count(*) from Users WHERE YEAR(CreationDate) = 2009