Skip to content

Instantly share code, notes, and snippets.

@LeeZee1

LeeZee1/gist:5d7707b66401e2a0b3098a449c3b1344

Last active June 22, 2021 15:50
Show Gist options
  • Save LeeZee1/5d7707b66401e2a0b3098a449c3b1344 to your computer and use it in GitHub Desktop.
Save LeeZee1/5d7707b66401e2a0b3098a449c3b1344 to your computer and use it in GitHub Desktop.
Download ZIP
Create game-by-game FIP over the course of multiple seasons using MySQL
Raw
gistfile1.txt
ALTER TABLE starting_pitcher_game_log ADD COLUMN FIP_g DOUBLE;
UPDATE starting_pitcher_game_log SET FIP_g = (((HR_a*13)+(3*(walks_a+HBP))-(2*strike_outs))/innings_pitched)+cFIP;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment