Distribution of bonuses between users?

Question

Algorithms

There are for example 5 users. (There can be as many users as you like)
id - points
1 - 3
2 - 1
3 - 5
4 - 8
5 - 9
For example, the total number of bonuses is 500.
How can I distribute bonuses between all users from higher to lower points?
Who scored more points (points) - more bonuses received.
The users are in the users database.
Thank you.

Answer 1

Um .... every day, the questions boil down to "How much is 2 + 2?"
What do you need to solve your problem?
1) Total number of bonuses.
2) The number of points scored by users. Taken by the following query:
"select sum(points) from users where 1;"
3) Calculate the number of bonuses for all users or a specific one, followed by a query, where :bal is the total number of points scored by users:
"select id, 500/100* ( points/:points) as bonus from users where 1"
Is it so difficult think for yourself, honestly?