2

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 reputation of more than 100 who have ever answered questions with the tag “sql” and “java”.


All I can do now is print names with a reputation greater than 100:

select DisplayName, Reputation from Users where Reputation > 100

How can I get tags of questions answered by a user in Stack Exchange Data Explorer?

3
  • Re "Write a SQL query": So it is a homework problem for a relational database class? Isn't the use of SEDE incidental (it happens to be a publicly accessible service with a (huge) data set)? That is, it really belongs on another site, like Stack Overflow? May 18 at 10:00
  • It was posted on Stack Overflow about two hours prior. May 18 at 10:00
  • Yes, I confused where to ask a question
    – yspesny
    May 18 at 22:16

1 Answer 1

5

A query like this needs a lot of JOINs, from users to answers to questions to tags. I wasn't convinced that would work on a database as large as Stack Overflow's, but this query nevertheless returns what you're looking for:

enter image description here

1
  • This is what I wanted, you helped a lot, thanks!
    – yspesny
    May 18 at 7:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .