News for hackers. Stuff that matters.
Re:Ask HN: For users with 10k+ karma, how much time do you s... by zimpenfish on Friday May 26, 2023 @06:18AM (#36082250)
If I'm querying 'abetusk's SQLite data correctly, 5000 karma would be the 99.64th percentile.

    sqlite> select count(*), sum(karma > 5000), sum(karma <= 5000) from users;
    558905|2018|556887
2018 from 558905 is 0.36%. Using the stats extension from sqlean confirms it.

    sqlite> select percentile(0+karma, 99.64) from users;
    4952.0
    sqlite> select percentile(0+karma, 99.65) from users;
    5070.50800000003

There are no comments on this comment yet.