|
|
|
|
|
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
|
|