• You can think of the table depicted here as merely a daily snapshot. It is based on actual records of games played. To consider only the last ten games I can deduct that you only need to modify any SQL that generated these snapshot records (for here we inserted them manually) .

    ----------------------------------------------------