All Questions
16
questions
2
votes
1
answer
145
views
How to get tags of questions answered by a user in Stack Exchange Data Explorer
I can't solve this problem: using a remote DBMS from the Stack Overflow site (URL: http://data.stackexchange.com/stackoverflow/query/new). Write a SQL query that displays the names of users with a ...
4
votes
1
answer
86
views
Why doesn't LIMIT work in Stack Exchange Data Explorer? [duplicate]
For some reason this isn't working in Data Explorer:
select ownerUserId, creationDate from posts LIMIT 1
I'm getting
Line 1: Incorrect syntax near '1'.
What am I doing wrong?
4
votes
3
answers
96
views
Find questions where any of the tags are in the title or body?
I would like to find posts where any of the tags are present in the title or body of the question, e.g. Python and C# are the tags and title is Fix my Python Problem?
SELECT TOP 10
Posts.Id,
Posts....
2
votes
1
answer
896
views
How do you join between Posts and Users in the Stack Overflow database?
I'm trying to join between stackoverflow.com's dataset Posts and Users files and I'm having trouble. I want to add the user profile of the question poster to a Post.
Do I use User.AccountId or User....
1
vote
3
answers
158
views
How do I modify this query to search for specific tags?
I am forking this query, which essentially outputs the time between the question being asked and the answer being given. However, I am trying to modify the query to only search for java. I tried this:
...
4
votes
1
answer
64
views
Problems filtering rows with Stack Exchange Data Explorer (SEDE)
I want to study how people behave where they are near to get a Tag Badge, so I need to:
Extract all the ID of users who have won a Tag Badge in a certain period of time.
See what Tag Badge they have ...
2
votes
1
answer
164
views
Data Explorer query to find answers of specific user based on a keyword
I'm looking for SQL query to use within Data Explorer, to bring back all my answers (per site, from only one site at a time) with my userid and with a particular keyword, in the body of my answers.
I ...
11
votes
2
answers
381
views
Why does data explorer not support ILIKE, SIMILAR TO, or regular expressions (~)?
Why does the data explorer not support ILIKE, SIMILAR TO, or regular expressions ~?
Talking to the devs:
Would it be possible to add that functionality?
9
votes
2
answers
210
views
How to use Data Explorer to find the most prolific closers on a site?
Goal: Make the list of Top 50 users who closed most questions on a site.
This means the questions that actually got closed, not pending close votes/flags. Deleted questions are excluded from ...
4
votes
2
answers
117
views
How I can get questions where the body is the same as the title?
It is know that many questions have the same body and title, So I wanted to create a query to show them all, but this don't work :
select
Posts.id as [Post Link], -- Question title.
Count(...
2
votes
1
answer
112
views
Querying for reputation of the commenter and its addressee using SEDE
How can I modify this Data Explorer query for the case when user of the comment is same as the poster, then the query should look for the tagged user in the comment and print the tagged user ...
0
votes
1
answer
105
views
Querying for name and rep of commenter and post OP using SEDE
I am new to T-SQL and would greatly appreciate help on the following query on the Stack Exchange Data Explorer.
For a given comment I need to display the username and reputation of whoever posted the ...
4
votes
1
answer
151
views
Trouble with fetching data
I'm trying to query the following data from stackexchange:
Fetch all the questions asked about Android, in past five years, and display post's id (a.iD), associated tags (a.Tags), for the person ...
5
votes
1
answer
633
views
SQL Query not returning hyperlink on data.stackexchange.com
I am basically a C programmer but I started on SQL today with the only purpose of fiddling around the data available on data.stackexchange.com. So please bear with me if my question is naive or ...
10
votes
2
answers
311
views
A query to get all posts that count for Archaeologist and Excavator
I've been playing with data-explorer to peruse stackoverflow more and learn some t-sql.
I managed to write this query, which lists out all posts the user has edited and then shows a difference in ...