Highest karma/submission

If you look at median comment score, there are three leaders with 3-- garbowza, greendestiny, and pg-- followed by a large number with 2. If you go by average the leaders are:

  (pg           1086 3.92) 
  (rwalker        14 3.57) 
  (cperciva       36 3.36) 
  (jmzachary      21 3.05) 
  (paul          160 2.98) 
  (elq            24 2.96) 
  (uuilly         26 2.88) 
  (greendestiny   23 2.83) 
  (rzwitserloot   18 2.78) 
  (smg            12 2.75) 
  (garbowza       12 2.75) 
  (nostrademons  440 2.75) 
  (pc             12 2.75)

Though it's kind of lame that I lead, the good news is that it looks like the extra upvotes I get for being the creator of the site probably don't amount to more than 1 per comment.

I recall nostrademons pointing out that most of his karma came from comments over submissions.

Whoops. Sure enough. Good thing I posted the source. I fixed the code and of course got different answers. Now PB is number 1.

(If anyone reading this later wonders what the parent comment is talking about, my original attempt to calculate this was wrong.)

Yeah but realistically that'd just return: ERROR: Unknown column 'submissions' or whatever because you'd probably have a separate submission table. Still, you're right that this simple stuff is what SQL is good at.

But having all that data in an in-memory hash is way more flexible and convenient. He can do any arbitrary operations on it, not just the stuff SQL and stored procedures are good at.