-
Notifications
You must be signed in to change notification settings - Fork 263
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Get team player was on during the game, not current team #157
Comments
You'll need to use the |
Thanks for responding so quickly. I tried using a.team in place of p[1], but it did not work. The 'Team' value for every player is 'None'. What do you mean by do it all manually? |
Doing it manually means one of two things:
|
Ok, thanks for the help! |
So I tried getting the team that the players were on at the time the game occurred using team from as_play_players, but it still returned the team the player is currently on. Can you give an example that shows how to get the team the player was on when the game occurred? |
here is an example of weekly targets and receptions per player - team is taken from play_player, which should be the team the player was on in that game (rather than his current team): WITH aggwt AS ( SELECT FROM aggwt WHERE |
I am trying to create a master table of every player (besides kickers) and each of their stats for each week. I want the 'Team' column in the table to show the team they were on for that game, not the team that they are currently on; but, I am not sure how to do this.
Any help is appreciated.
Thanks
The text was updated successfully, but these errors were encountered: