High Scores

Instructions

Manage a game player's High Score list.

Your task is to build a high-score component of the classic Frogger game, one of the highest selling and most addictive games of all time, and a classic of the arcade era. Your task is to write methods that return the highest score from the list, the last added score and the three highest scores.

SQLite-specific instructions

To populate the results table, there are four "properties" you must consider:

• scores: You must aggregate all scores for each game_id, and store the scores in a comma-separated string. The scores must appear in the same order as they were inserted into the scores table.
• latest: You must find the last score inserted into the scores table.
• personalBest: Find the maximum score for each game_id.
• personalTopThree: Find the three highest scores for each game_id, and aggregate them into a comma-separated string, sorted in descending order.