The Stack Exchange Data Explorer is a great tool. I've noticed many queries regarding site statistics, top lists, and also user-specific queries such as badge progress.
Nice examples giving insights about the TeX.SX site and its content are:
- Which country are the users from?
- Top answers
- Most favorited questions
- Number of questions and answers per month
- Most viewed questions
- Total number of registered users over time
- Top-rated comments
I thought about TeX related queries, involving tags, votes, and views or even syntax for example. They could be a demonstration of how we could use the data explorer.
What ideas do people have for a useful, interesting, TeX-related query? And what queries have people created?
For those interested in creating queries, here's a useful "question" on meta.SO about the database schema; moreover there are quite a few questions on meta.SO about the data explorer, they are generally tagged "data-explorer" so a good place to start is with this search.