AngularJS metrics by year

0

Please login or register to vote for this query.

(click on this box to dismiss)

Esperanto Language

Q&A for teachers and students of the Esperanto language

Select '2016' as 'Year', sum(ViewCount) as ViewCount, sum(AnswerCount) as AnswerCount, sum(CommentCount) as CommentCount, sum(FavoriteCount) as FavoriteCount, sum(Score) as Score from Posts
where Tags like '%angularjs%'
and CreationDate >= cast('01/01/2016 00:00:00.000' as datetime)
and CreationDate <= cast('12/31/2016 23:59:59.999' as datetime)

union

Select '2017' as 'Year', sum(ViewCount) as ViewCount, sum(AnswerCount) as AnswerCount, sum(CommentCount) as CommentCount, sum(FavoriteCount) as FavoriteCount, sum(Score) as Score from Posts
where Tags like '%angularjs%'
and CreationDate >= cast('01/01/2017 00:00:00.000' as datetime)
and CreationDate <= cast('12/31/2017 23:59:59.999' as datetime)

union 

Select '2018', sum(ViewCount), sum(AnswerCount), sum(CommentCount), sum(FavoriteCount), sum(Score) from Posts
where Tags like '%angularjs%'
and CreationDate >= cast('01/01/2018 00:00:00.000' as datetime)
and CreationDate <= cast('12/31/2018 23:59:59.999' as datetime)

union

Select '2019', sum(ViewCount), sum(AnswerCount), sum(CommentCount), sum(FavoriteCount), sum(Score) from Posts
where Tags like '%angularjs%'
and CreationDate >= cast('01/01/2019 00:00:00.000' as datetime)
and CreationDate <= cast('12/31/2019 23:59:59.999' as datetime)

union

Select '2020' as 'Year', sum(ViewCount) as ViewCount, sum(AnswerCount) as AnswerCount, sum(CommentCount) as CommentCount, sum(FavoriteCount) as FavoriteCount, sum(Score) as Score from Posts
where Tags like '%angularjs%'
and CreationDate >= cast('01/01/2020 00:00:00.000' as datetime)
and CreationDate <= cast('12/31/2020 23:59:59.999' as datetime);

Enter Parameters

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