Query problem - top 5 validation

T

tw

Hi,

I have a problem to run a query like this scenario:

i have players in a table who have scored in many matches and i want to take
the 5 latest.

The latest i want to multiply with 1.0 and then after with 0.8, 0.6, 0.4 and
finally 0.2.

playerid round score
1, 10, 122
1, 9, 123
1, 8, 222
1, 7, 333
1, 6, 222

And i want to multiply 122 * 1 + 123*0,8 + 222*0,6 + 333*0,4 + 222*0,2

Even handle if there are only 3 score.

Help, who can i do that in sql?

Regards
TW
 
D

Duane Hookom

Are the rounds always consecutive with no gaps? Is the highest numbered
round the "latest"? I expect there is more than one player?
 
Top