20
$\begingroup$

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.

$\endgroup$
3
  • 3
    $\begingroup$ 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. $\endgroup$
    – Martin Sleziak
    Commented Aug 25, 2018 at 13:04
  • $\begingroup$ @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. $\endgroup$
    – Martin Sleziak
    Commented Aug 27, 2018 at 12:06
  • $\begingroup$ @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. $\endgroup$
    – Peter Phipps
    Commented Aug 27, 2018 at 12:29

1 Answer 1

Reset to default
12
$\begingroup$

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.

$\endgroup$
7
  • 1
    $\begingroup$ As pointed out by Peter Taylor, it should be possible get rid of the join of two tables without influencing the results. $\endgroup$
    – Martin Sleziak
    Commented Aug 27, 2018 at 14:55
  • $\begingroup$ Yes, this works. $\endgroup$
    – Nik Bren
    Commented Aug 27, 2018 at 15:07
  • $\begingroup$ Thanks Nik Pronko and @MartinSleziak, that's just what I wanted. $\endgroup$
    – Peter Phipps
    Commented Aug 27, 2018 at 16:15
  • 4
    $\begingroup$ 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. $\endgroup$
    – joriki
    Commented Sep 2, 2018 at 11:06
  • $\begingroup$ 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. $\endgroup$
    – Rob
    Commented Sep 3, 2018 at 0:36
  • 2
    $\begingroup$ @joriki And gave away over 3000 reputation in bounties. $\endgroup$
    – Horizon
    Commented Sep 4, 2018 at 4:08
  • $\begingroup$ Note: owing to the great reputation give-away (when upvotes on questions became worth +10 rep points), user Laila Podlesny has passed the 10K threshhold. $\endgroup$
    – Peter Phipps
    Commented Nov 14, 2019 at 10:00

You must log in to answer this question.

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