I have a table called "GamesTable"
Columns are ID, Date, PlayerName, GamesWon,GamesLost,GamePlayed( this has always value 1)
Now I want to make a query to get the average of games won/Lost and the sum of Games Played for every player BUT in his last 5 matches. I have no idea how I can get the last 5 matches for each and every player out of the GamesTable.
Can you help me with this?