Recently the 'Moderation results' were published across all Stack Exchange sites.
On my main site, Drupal Answers, I noticed a drastic fall in moderation actions, flagging etc. from the results that were published last year.
I then wanted to discover further on SEDE to get the difference of the overall activity of the site from 2018-2019.
By the overall activity, I mean the amount of answers, questions, comments etc.
Since I don’t have experience writing SEDE queries I ask here for guidance how to write such a query. One day I will look into writing SEDE queries and getting to know the database.
I want to have a query that returns the difference of the following data from 2018-2019 (it should be possible to make start and end year dynamic).
- Amount of questions
- Amount of answers
- Amount of comments
- Amount of new contributors
Don’t know if there’s more that makes sense to include in the query, feel free to comment if you think there’s something that should be added to the query.