Hacker News new | ask | show | jobs
by zimpenfish 1122 days ago
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