0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to improve their interpersonal communication skills

(SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2010-01-01 00:00:00' AND CreationDate  <= '2010-12-31 00:00:00'
)
 union
 ( SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2011-01-01 00:00:00' AND CreationDate  <= '2011-12-31 00:00:00'
)
union
 ( SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2012-01-01 00:00:00' AND CreationDate  <= '2012-12-31 00:00:00'
)
union
 ( SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2013-01-01 00:00:00' AND CreationDate  <= '2013-12-31 00:00:00'
)
union
 ( SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2014-01-01 00:00:00' AND CreationDate  <= '2014-12-31 00:00:00'
)
union
 ( SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2015-01-01 00:00:00' AND CreationDate  <= '2015-12-31 00:00:00'
)
union
 ( SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2016-01-01 00:00:00' AND CreationDate  <= '2016-12-31 00:00:00'
)
union
 ( SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2017-01-01 00:00:00' AND CreationDate  <= '2017-12-31 00:00:00'
)
union
 ( SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2018-01-01 00:00:00' AND CreationDate  <= '2018-12-31 00:00:00'
)
union
 ( SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2019-01-01 00:00:00' AND CreationDate  <= '2019-12-31 00:00:00'
)
union
 ( SELECT COUNT(*) 
FROM Users 
WHERE CreationDate  >= '2020-01-01 00:00:00' AND CreationDate  <= '2020-03-31 00:00:00'
)

fork query

edited mar 31

created mar 31 anonymous