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 reps built entirely from asking?

Edit
I have spent some time trying to convert the two Data Explorer queries that Martin posted into one that would do what I want. My SQL skills aren't great, however, and I have so far been unsuccessful.

  • 3
    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 Sleziak Aug 25 at 13:04
  • @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 Sleziak Aug 27 at 12:06
  • @MartinSleziak I was trying to combine the question and answer queries into one that selected users with a total answer score of zero and then ordered by total question score. – Peter Phipps Aug 27 at 12:29
up vote 12 down vote accepted

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-answer-score?num=100

It turns out that the top user without answer scores is Laila Podlesny, and her reputation is still under 10k.

  • 1
    As pointed out by Peter Taylor, it should be possible get rid of the join of two tables without influencing the results. – Martin Sleziak Aug 27 at 14:55
  • Yes, this works. – Nik Pronko Aug 27 at 15:07
  • Thanks Nik Pronko and @MartinSleziak, that's just what I wanted. – Peter Phipps Aug 27 at 16:15
  • 4
    Perhaps its worth noting that Laila Podlesny earned her $3722$ reputation points by asking only $33$ questions, an impressive average of more than $100$ points (corresponding to more than $20$ upvotes) per question. And this is just because of daily point restrictions -- she actually got a total of $1300$ upvotes, a remarkable average of almost $40$ per question. – joriki Sep 2 at 11:06
  • Thanks for your answer --- It might be interesting to modify this SEDE: Who is the user with highest combined reputation from all Stack Exchange sites? so that it considers 'question only' users instead of total score on all sites. – Rob Sep 3 at 0:36
  • 2
    @joriki And gave away over 3000 reputation in bounties. – Alex Clark Sep 4 at 4:08

You must log in to answer this question.

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