AngularJS metrics by year

0

Please login or register to vote for this query.

(click on this box to dismiss)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

Select '2017', sum(ViewCount), sum(AnswerCount), sum(CommentCount), sum(FavoriteCount), sum(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);

Enter Parameters

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