I was playing with StackQL and asked myself. Are there people who have as much rep as their highest voted question/answer (as in, they've only gotten rep from that one question/answer).
The query isn't that complicated but you have to filter out the people who have answered one question, gotten 1 upvote and have 10 rep. Since thats no fun. So I limited it to >= 100 rep.
SELECT Posts.Id, Posts.Score, Users.Id, Users.Reputation FROM Posts LEFT JOIN Users ON Users.Id = Posts.OwnerUserId WHERE (Posts.Score * 10) = Users.Reputation AND Users.Reputation >= 100 ORDER BY Users.Reputation DESC
These are the questions / answers.
- Answer to - Boxing when using generics in C# (230 rep)
- Question - Why would I want to use Interfaces? (220 rep)
- Question - What is the difference between an asp.net web method and a wcf service? (180 rep)
- Answer to - Best Java book you have read so far (150 rep) (this might be a fluke though)
- Question - Computer science final year project ideas (150 rep)
- Question - Determining if ASP.Net is properly registered (150 rep)
- Question - How relevant is Win32 programming to modern professionals? (110 rep)
- Question - What would be a good sample project to ask a prospective programmer to code during the hiring process? (110 rep)
The questions are often interesting but generic but it's the answers that intrigue me. For example the top one. That user has not done anything but voted a few times and answered that one answer.
The fluke one might be because of CW not being enabled at the start of his answers. He has two, both CW answers.
The third answer is similar to the first one, although he has answered two questions but the other answer has 0 votes.
Even though the list isn't that exciting, it's still a bit interesting.
I did a query with +100. I was worried that there would be to many cases where people had gotten upvotes from other places.
SELECT Posts.Id, Posts.Score, Users.Id, Users.Reputation FROM Posts LEFT JOIN Users ON Users.Id = Posts.OwnerUserId WHERE (Posts.Score * 10) + 100 = Users.Reputation AND Users.Reputation >= 200 ORDER BY Users.Reputation DESC
I did >= 200 because otherwise I got pages and pages of results. This is the breakdown of the query.
- Tim (309 rep). Got 210 from one question. Two account associations with SO. But no rep on SO from that.
- giltotherescue (270 rep).. Rep from other questions. No assoc.
- Mohit Ranka (240 rep). Most from one of his 28 questions. Matched query because he has one CW question with 14 votes. No assoc
- rofly (230 rep). Similar situation as Mohit. No assoc
- qrunchmonkey (210 rep). Rep from other stuff. No assoc.
- Daz (200 rep). Rep from other stuff. No assoc.
So account association has no effect here, we just get bad results.
Looks like I had forgotten the initial 1 rep. So I have fixed the query (I'll leave the original stuff intact) But what happened to the starting 1 rep is a good question.
So here is the same list but with a fixed query.
SELECT Posts.Id, Posts.Score, Users.Id, Users.Reputation FROM Posts LEFT JOIN Users ON Users.Id = Posts.OwnerUserId WHERE (Posts.Score * 10) + 1 = Users.Reputation AND Users.Reputation >= 300 ORDER BY Users.Reputation DESC
I limited this one to >= 300 since the list was pretty long.