Project Description:
Create a database or other software where the user should be able to enter half time and full time results for an unlimited number of teams that can be organised into groups (no other data entry required).
From this data I want to be able to click on a team name and then search how many times that team was involved in certain result based scenarios. For example, what percentage of games for that team contained the following criteria:
2 or more goals in 1st half, 2 or more goals in 2nd half, 3 or more goals in total game, 4 or more goals in total game, selected team score 2 or more goals in game, selected team scored 3 or more goals in game, selected team conceded 0 goals.
I want to be able to sort the data based on whether the team was home or away (for database purposes, the first team entered would be home and the second away).
The user should be able to pick a frame for the data extract, i.e. results based only on a selected # of recorded games (last 10 games for example).