Comment by Imustaskforhelp

https://news.ycombinator.com/user?id=proven

Here's the Query that I ran on play.clickhouse.com (Please note that both the queries that I am about to give are AI generated)

SELECT id, argMax(karma, update_time) AS current_karma FROM hackernews_changes_profiles GROUP BY id ORDER BY current_karma ASC LIMIT 5

№ id current_karma1 1 Proven -247

2 VentureHawk -89

3 adamyormark -50

4 oldpersonintx2 -45

5 sevenstar -35

So proven has the lowest karma.

While at it, Here's the query for the most upvoted (karma) people on hackernews

SELECT id, argMax(karma, update_time) AS current_karma FROM hackernews_changes_profiles GROUP BY id ORDER BY current_karma DESC LIMIT 5

id current_karma 1 tptacek 414947

2 jacquesm 235042

3 ingve 214146

4 todsacerdoti 204814

5 rbanffy 184030

I remember tptacek because he is the second person of all the people (behind dragonwriter) and he has written 14.37 Volumes worth of game of thrones.

Hope this helps. I just ran the query because I was curious to find the results :D

I can add this query to the website, but one of my worries (even with this post) is that people might try to now benchmark it which wasn't my intention & it will fail to be a good measure (someone mentioned the goodhart's law which is correct/apt here)