lets say we have 100,000 accounts each with a collectibility score. of course there might be a lot of accounts that have the same score and some that have 0 score. i would like a SQL formula to compute deciles/twentiles. the scores range from 0 to 7000.
so that in the end we know that based on this universe eg scores 6500-7000 is the 20th and 5000-6499 is 19th twentile and 0-500 is 1st twnetile etc etc