ranking - 10 period moving average in MySql without using date -


I have a table of goalkeeper data, below snipet

  year gameid player sv% gamenum 2009 200165 John Smith 0.923 0165 2009 209 754 John Smith 1.000 9754 2009 206 938 John Smith 1.000 6938 2009 206 155 John Smith 0.833 6155 2009 203 021 John Smith 0.667 3021 2009 206 472 John Smith 0.909 6472 2009 209 524 John Smith 0.833 9524 2009 209 351 John Smith 0.800 9351 2009 203 056 John Smith 1.000 3056 2009 206 761 John Smith 0.935 6761 2009 200 466 John Smith 0.954 0466 2009 204 171 John Smith 0.932 4171 2009 207 876 John Smith 0.958 7876 2009 201 581 John Smith 0.941 1581 2009 205286 John scheme Thessalonica 0.930 5286 2009 208 991 John Smith 0.961 8991 2009 202 696 John Smith 0.916 2696 2009 206 401 John Smith 0.935 6401 2009 200 106 John Smith 0.921 0106 2009 201 381 John Smith .918 1381   

I have 10 games each goalkeeper Want to get average moving, but I do not have dates or game numbers such as their first, second, third game etc. Game ID is assigned to an LSO order in which they are played on the league level, the game will be his first match of 200,106 sessions, and 200,165 may then 2, and so

My question this is:. How can I get maximum (10 games moving averages) and minutes (10 games moving average) for each year classified on the basis of each goalkeeper?

Besides, is there a way to rank the game ID by the goalkeeper, using MySQL the year? <10 Moving Average means that if you have less than 10 games then there is no meaningful average (no) enough games. If you had 12 games, then the average average <3>

  1-10 (average) 2-11 (average) 3-12 (average) is taken between the max / min   

this will be the most effective way to MySQL < / P>

 . (Which contains 13 @ variables which allow for rotation and rotating the last 10 values ​​in the variable, keeping the player, year, gameid   

come by Esh, it takes only one pass through the data, to make the average, @player, @year, @rownumber track) an external question only the minimum / maximum of the derived table. I am not currently ready for muscle at this time.

Comments