0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT 
  datepart(year, CreationDate) as 'year',
  Count(Id) as Qtty, 
  SUM(ViewCount) as SView,
  AVG(ViewCount) as MView, 
  STDEV(ViewCount) as StdView,
  SUM(AnswerCount) as SAnswer,
  AVG(AnswerCount) as MAnswer,
  STDEV(AnswerCount) as StdAnswer,
  SUM(CommentCount) as SComment,
  AVG(CommentCount) as MComment,
  STDEV(CommentCount) as StdComment,
  SUM(FavoriteCount) as SFavorite,
  AVG(FavoriteCount) as MFavorite,
  STDEV(FavoriteCount) as StdFavorite,
  SUM(Score) as SScore,
  AVG(Score) as MScore,
  STDEV(Score) as StdScore
FROM Posts
WHERE Tags like '%angularjs%'
and CreationDate between '2012-01-01' and '2021-12-31'
GROUP BY datepart(year, CreationDate)
ORDER BY datepart(year, CreationDate) ASC;

fork query

edited dec 2

created dec 2 anonymous