How can I get the statistics data of how many people ask questions and how many answer here? I'm curious about the distributions and seeing if more people ask than answer.
-
"and seeing if more people ask than answer" That's naturally very likely.– πάντα ῥεῖCommented Mar 9, 2019 at 13:47
-
3You can get stats from the Stack Exchange Data Explorer– Robert LongsonCommented Mar 9, 2019 at 13:56
Add a comment
|
1 Answer
Using SEDE, you can run this query:
select 'questioners', count(distinct owneruserid) from posts where parentid is null and title is not null
union
select 'answerers', count(distinct owneruserid) from posts where parentid is not null
Running it for Meta Stack Exchange, I get:
- questioners: 24035
- answerers: 10888
Note that deleted users all have the same id: null and deleted posts are not listed in SEDE, so both of the numbers produced by the query are underestimates.
