To test it, I have used a site and tag where I have several answers: For comparison here are questions with my answer: Questions in a given tag with my answer
I am pretty sure that it can be improved in various ways, but I have at least tried to create some query concerning your edited question - you can see it in the SEDE chatroom. — Martin7 secs ago
Just to clarify, this is not about original question, but about the request edited into the question later:
> To get top voted questions by tag, that are not answered by me.
I should probably have included ViewCount. But I suppose it is not that difficult to modify the query if you want to have the questions sorte by views.
@Khemraj We will see whether some of the users more experienced with SEDE will have some suggestion. In any case, I do not see how the original question could be implemented - but this has already been mentioned in the comments.
SEDE can't see how you voted. You can get the top voted questions questions per tag though. — Robert Longson2 hours ago
During the recent moderator election I found myself wondering if there are any high-rep users (> 10K) who have amassed that many reputation points solely by asking questions and not by answering any.
I'm not interested in identifying particular users, but do we have a way of finding the highest ...
Using data explorer you can find users with highest total score from answers and from questions. Total score is different from reputation earned (for example, it does not take into account reputation cap), but it is a rough approximation. — Martin Sleziakyesterday
Edit I have spent some time trying to convert the two Data Explorer queries that Marting posted into one that would do what I want. My SQL skills aren't great, however, and I have so far been unsuccessful.
@PeterPhipps Would you clarify a bit what exactly do you want to achieve "by combining two queries into one"? It's a bit unclear to me what exactly you're looking for. If you wish, we can discuss this further in the SEDE chatroom so that we do not leave too many comments here. — Martin Sleziak1 min ago
Maybe I originally misunderstood the question.
Perhaps you want high rep users that have zero answers or at least zero upvoted answers?
Hi Martin. I was trying to combine the question and answer queries into one that selected users with an answer score of zero and then ordered by question score.
Still, for example this user is listed there - all their answers are upvoted but one of them is accepted, so they earned reputation from the accepted answer.
I suppose that it would be possible to modify query somehow to count additionally also number of accepted answer, but it seems to me that I would need to include somehow one more join and the query becomes more complicated.
And I wouldn't be surprised if we find out that I've made a mistake somewhere in the queries linked above.
We will see whether some of the more experienced users notice either your question on meta or the conversation here in chat - possibly somebody will suggest better queries than what I did above.
BTW another thing which this query ignores (and which influences reputation) is CW posts.
I suppose that it's expected that some of the users who posted highly upvoted questions should appear among the top results, indeed I see some name from the query when I search for highly upvoted questions directly on the site.
@Martin There is one change which doesn't seem to have any downside and simplifies the query: remove the join to the Users table, which isn't necessary: data.stackexchange.com/math/query/891056/…
I rewrote query by Martin Sleziak into this:
https://data.stackexchange.com/math/query/891053/top-users-with-no-answer-scores?num=100
Hope it helps.
If still joining on users, you can explicitly view reputation:
https://data.stackexchange.com/math/query/891096/top-reputation-users-with-no-ans...