0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for operations research and analytics professionals, educators, and students

SELECT YEAR(CreationDate) as CreationYear, COUNT(*) as TotalPostsCreated, SUM(ViewCount) as TotalViewCount, SUM(CommentCount) as TotalCommentCount, SUM(AnswerCount) as TotalAnswerCount, SUM(FavoriteCount) as TotalFavoriteCount, SUM(Score) as TotalScore FROM Posts WHERE Tags LIKE '%python%' GROUP BY YEAR(CreationDate) ORDER BY YEAR(CreationDate)

fork query

edited jan 27

created jan 27 jon.doe38054