I have a table with the following rows for example:
and I want to show the user what hes rank (in numbers).
The total power is the Strength+Speed+Power.
If there are 2 users:
user1: 20 strength, 10 speed , 10 power (sum: 40)
user2: 30 strength,15 speed, 15 power (sum:60)
it will show to user1: you rank is #2.
How I can build such a query that does that and give me the count or orders by the sum so I can run a loop until it find the right user?
Thanks in advance!