OPS、三振率(AB/Kの逆数)の計算式が間違っていたので修正。
| @@ -4,9 +4,9 @@ | ||
| 4 | 4 | name, |
| 5 | 5 | (sum(hit)/sum(at_bats)) as average, |
| 6 | 6 | ((sum(hit)+sum(twobase)*1+sum(homerun)*2)/sum(at_bats)) as SLG, |
| 7 | - (sum(hit)/sum(at_bats))+((sum(hit)+sum(twobase)*1+sum(homerun)*2)/sum(at_bats)) as OPS, | |
| 8 | - (sum(hit)+sum(four_ball))/sum(tpa) as OBP, | |
| 9 | - sum(strike_out)/sum(tpa) as not_strike_out, | |
| 7 | + ((sum(hit)+sum(four_ball))/sum(tpa))+((sum(hit)+sum(twobase)*1+sum(homerun)*2)/sum(at_bats)) as OPS, | |
| 8 | + (sum(hit)+sum(four_ball))/sum(tpa) as OBP, | |
| 9 | + sum(strike_out)/sum(at_bats) as not_strike_out, | |
| 10 | 10 | sum(tpa) as tpa, |
| 11 | 11 | sum(at_bats) as at_bats, |
| 12 | 12 | sum(hit) as hit, |
trunk/JCBLScore/src/main/resources/cx/myhome/ckoshien/sql/BattingResult.sql