All Questions
Tagged with stackexchange sql
75 questions
2
votes
1
answer
108
views
Determining the least dangerous tags with over 1K answers to answer
So I thought I'd take another shot at making a SEDE query after being somewhat inactive after a while.
Essentially what this does is that it takes the tags that have at least 1000 answers for that tag ...
- 619
6
votes
1
answer
922
views
Show how close a user is to being unsung
So this morning, I decided to create a SEDE query that answers the age-old question "How close am I to being Unsung?" because I recently polished up my first SEDE query and I realized that I ...
- 619
3
votes
1
answer
114
views
SE Data Explorer: Users by City
I view users by city using this SQL query:
...
2
votes
1
answer
278
views
How to make this query better (e.g. avoid repeating subquery in a query)?
Stack Exchange provides access to query their MS SQL databases. They have a table Posts where each post is either a question or an answer (see the schema on right ...
- 121
1
vote
1
answer
145
views
Get average post score of TOP 10 tags on StackOverflow using Stack Exchange Data Explorer
I want to use the Stack exchange data explorer in order to display some basic information about the top tags.
The query should print the number of questions and answers, the average number of answers ...
- 129
5
votes
1
answer
70
views
State the word count for a given Stack Exchange user
Sometimes I like to use word count to describe someone's contributions to Stack Exchange, so I wrote a query to state the word count for a given Stack Exchange user using SEDE. click to run it online
<...
- 151
8
votes
1
answer
108
views
Zombie killers ranking
Code Review has a Zombie Problem and, in comparison to The Walking Dead TV Show, our survival doesn't depend on killing them all day every day.
As a potential solution, I though it would be ...
- 12.6k
5
votes
1
answer
80
views
SEDE query to calculate net migrations quarterly from ELU to ELL
Over on EL&U Meta, someone raised the question of how many net migrations there are to/from our sister site, ELL.
The following SEDE query calculates the net migrations by quarter (...
- 152
6
votes
2
answers
147
views
Find how much reputation a user had on a given date
I saw this question on MSE and went ahead and wrote a solution to it:
https://meta.stackexchange.com/questions/313561/determining-users-reputation-as-of-particular-date
This calculates the ...
- 330
5
votes
1
answer
68
views
Stack Overflow Tag Usage
I am trying to efficiently use the SEDE tool to get a list of tags a user has answered questions on, and their stats on each Tag.
My code works for my account in 3185 ms, but if I try to run it on @...
- 515
9
votes
1
answer
151
views
The seasoned Zombie sniper: a query to find unanswered questions with specific tags
The query (on SEDE)
This query builds upon the previous and includes the suggestions by rofl as well as the now mentioned activity index.
...
- 19.6k
11
votes
1
answer
135
views
The sniper: a Zombie searcher for specific tags
Sometimes, it's not enough to know what the easy prey is. You also need to know whether you will be able to hunt it down. What good is an almost turned haskell zombie if you cannot read the functional ...
- 19.6k
15
votes
1
answer
1k
views
A wounded Zombie finder, or: how to find the almost dead undead?
The Zombies are on their way to eat our statistics. Fortunately, we have a way to get rid of them: our votes. However, we need to find them first. The /unanswered section is too large and contains ...
- 19.6k
3
votes
1
answer
143
views
SE main site tag ratings based on Wilson score confidence interval
In "How Not To Sort By Average Rating", Evan Miller explained in simple terms and demonstrated with compelling examples that the usual naïve methods of calculating the average rating are ...
- 1,190
1
vote
1
answer
100
views
Posts that probably need editing
I wrote this Data Explorer query (reproduced below) some time ago that helped identify posts containing potential spelling/punctuation errors and earned me a Copy Editor badge on Anime.SE.
...
- 1,190