I manage a little league soccer team.
I have a table called “Players” with all the players.
I have a table calles “Games” with all the games.
The table “Games” has a column called “Type” because some games are indoors, some are outdoors.
The table “Games” also has a column called “Attendance” where I list all the players that attended that game.
My question is as follows: in the table “Players”, can I make a new column that counts the number of outdoor games that this specific player has attended?