SELECT (SELECT count (id) from ReviewTasks where Creation...

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Great Outdoors

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

SELECT 
 (SELECT count (id)
 from ReviewTasks
 where CreationDate > ='2012-01-01' and CreationDate <'2012-05-01') as '2012',
 (SELECT count (id)
 from ReviewTasks
 where CreationDate > ='2013-01-01' and CreationDate <'2013-05-01') as '2013',
 (SELECT count (id)
 from ReviewTasks
 where CreationDate > ='2014-01-01' and CreationDate <'2014-05-01') as '2014',
 (SELECT count (id)
 from ReviewTasks
 where CreationDate > ='2015-01-01' and CreationDate <'2015-05-01') as '2015',
 (SELECT count (id)
 from ReviewTasks
 where CreationDate > ='2016-01-01' and CreationDate <'2016-05-01') as '2016',
 (SELECT count (id)
 from ReviewTasks
 where CreationDate > ='2017-01-01' and CreationDate <'2017-05-01') as '2017',
 (SELECT count (id)
 from ReviewTasks
 where CreationDate > ='2018-01-01' and CreationDate <'2018-05-01') as '2018',
 (SELECT count (id)
 from ReviewTasks
 where CreationDate > ='2019-01-01' and CreationDate <'2019-05-01' )as '2019'

Enter Parameters

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