All Questions
10
questions
4
votes
1
answer
64
views
What is the difference between DisplayName and Id on the Stack Exchange Data Explorer Users table?
I am trying to pull a list of all users who have commented on an answer and tie it back to their User profile, if one exists. However, not all Comments table records have a UserId associated with them ...
5
votes
1
answer
80
views
Missing UserIDs
I'm working on some performance tests for my ORM.
I just noticed this with the 2010; these two queries return results.
SELECT distinct UserId FROM Comments WHERE not UserId in (Select ID From Users) ...
- 151
3
votes
2
answers
103
views
Number of users in a Stack Overflow SEDE query
I tried to run this query on SEDE:
SELECT *
FROM
(
SELECT
ROW_NUMBER() OVER (ORDER BY u.Displayname DESC) AS row,
u.Id, u.Reputation
FROM
Users u
WHERE
...
- 125
7
votes
1
answer
59
views
What can I do to find how many distinct users contribute to all the posts and comments this query seaches for?
I have used the query below to form a result table and now I need to find how many users are contributing to it. Is there any way I can achieve that?
SELECT p.Title,p.Body,c.Text
FROM Posts p
JOIN ...
- 303
6
votes
1
answer
194
views
Is it possible to create a Data Explorer query that returns questions from users who have more answers than questions?
I've found a query that returns questions from users with a certain minimum reputation:
select top 20 p.id as [Post Link], p.score, p.viewcount, p.answercount, p.tags,
u.reputation
from posts p, ...
- 1,763
1
vote
0
answers
31
views
Not able to see Location in Stack Exchange Data Explorer [duplicate]
I am using the following query in Stack Exchange Data Explorer:
SELECT Id, DisplayName, Reputation, Location
FROM users
WHERE Id = '3628106'
ORDER BY Reputation DESC
But I don't see Location in the ...
- 131
4
votes
1
answer
97
views
How can I get the summary of questions a user ask from the Stack Overflow data dump?
I need information about how many questions a user asks, how many of them are resolved, and how many of them remain unanswered. Is there any way to get this information from the SO data dump?
- 179
2
votes
1
answer
88
views
Recreate a query for the tags associated with a user based on time filter
I'm looking to recreate a SEDE query that represents the tags associated with a user based on a specific time filter. Consider, for example, the list of users sorted by reputation, filtered by week:
...
- 13.5k
0
votes
0
answers
31
views
Who does the data explorer think I am John.Doe [duplicate]
I logged into data-explorer for the first time 9I have viewed others' queries but have not created one myself). When I log in with the StackExchange Open Id provider, I am shown as john.doe13574.
...
- 103
2
votes
1
answer
368
views
Finding specific users by their location and a tag score
I want to see who has the highest score in a specific tag (for example c#) in my country.
Is there any query or script for that?
I've found this query, but it doesn't work. Can any one take a look at ...
- 131