Tracking a basketball game
I want to track possessions of basketball games for our players.
We have 82 games and want to track a specific thing called screening and if a player makes contact with another player or not. I'd like to see if it led to a basket and how many points we scored on a screen.
After the game I'd like a detailed report on each player after the game on how many screens they attempted and made contact as well as a percentage. There are two types of screens and want to not only get the total screens but the two types and percentage connected as well.
I assume a table for players as well as games and join them
id also like to keep the total for the season as well as on a per game basis.