2 ms·
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
by zimpenfish 3y 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