In addition to using variables, Wyers also does the other thing I had thought about using: an intermediate table to store the runMinus, runPlus, and wOBAScale values. \u00a0On the one hand, this makes sense as we will only have to write out the calculations once and then refer to them in this table when we need them. \u00a0On the other hand, if we managed to use variables for defining the run values in the previous table, we should be able to do so with these values as well.<\/p>\n
Also, in this table, we define league wOBA. \u00a0It makes sense that the weighted On Base Average for the entire league is just the entire league’s On Base Percentage. \u00a0If we’re looking at an average for the entire league, there is nothing to weigh it against. \u00a0We’ll see this idea again when we look at wRC+.<\/p>\n
A few minor adjustments to the code to allow for OOTP’s naming conventions and one final difference: \u00a0I’m taking the batting stats from the league_history_batting table rather than the players_ file. \u00a0It’s already there and there are far fewer rows to sort through. \u00a0And given that we’re not filtering out any stats, it’s silly not to use it. \u00a0And, because we’re using it, we can use the column for singles (s) rather than deriving singles from H-2b-3b-HR.<\/p>\n
#Creating an intermediate table so as not to have to write out formulae for rumMinus etc.\r\nDROP TABLE IF EXISTS tblRunValues1A;\r\nCREATE TABLE IF NOT EXISTS tblRunValues1A AS\r\nSELECT r.year\r\n, r.league_id\r\n, r.RperOut \r\n, r.runBB \r\n, r.runHB \r\n, r.run1B \r\n, r.run2B \r\n, r.run3B \r\n, r.runHR \r\n, r.runSB \r\n, r.runCS \r\n, SUM(runBB*(BB-IBB) + runHB * HP + run1B * s + run2B * d \r\n + run3B * t + 1.4 * HR + runSB * SB - runCS * CS) \r\n \/ SUM(AB - H + SF) AS runMinus \r\n\r\n, SUM(runBB * (BB-IBB) + runHB * HP + run1B * s + run2B * d \r\n + run3B * t + 1.4 * HR + runSB * SB - runCS * CS) \r\n \/ SUM(BB-IBB + HP + H) AS runPlus\r\n\r\n, SUM(H+BB-IBB+HP) \/ SUM(AB+BB-IBB+HP+SF) AS wOBA \r\n \r\nFROM tblRunValues r\r\nINNER JOIN league_history_batting_stats \r\n ON r.year=league_history_batting_stats.year \r\n AND r.league_id=league_history_batting_stats.league_id\r\n\r\n \r\nGROUP BY \r\nr.year\r\n, r.league_id\r\n, r.RperOut \r\n, r.runBB \r\n, r.runHB \r\n, r.run1B \r\n, r.run2B \r\n, r.run3B \r\n, r.runHR \r\n, r.runSB \r\n, r.runCS \r\n \r\nORDER BY \r\nr.year DESC;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"In addition to using variables, Wyers also does the other thing I had thought about using: an intermediate table to store the runMinus, runPlus, and wOBAScale values. \u00a0On the one hand, this makes sense as we will only have to write out the calculations once and then refer to them in this table when we… Continue reading Run Environment 5: An Intermediate Table<\/span>