Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 8.02 ms
Record Count: 14
Cached: No
Lazy: No
SQL:
SELECT ptsR=SUM(feeds.scored_points),
gmsR=SUM(feeds.games),
ppgR=(convert(real,SUM(feeds.scored_points)) / convert(real,SUM(feeds.games))),
wR=SUM(feeds.wins),
sR=SUM(feeds.saves),
cgR=SUM(feeds.complete_game),
wsbR=SUM(feeds.ws_points),
nwsR=SUM(feeds.nws_points),
nohR=SUM(feeds.no_hitter),
pfgR=SUM(feeds.perfect_game),startR=sum(feeds.starts),
reliefR=sum(feeds.relief),proteam,year=substring(period,1,4)
from feeds
WHERE player = '8179'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
154105.41008360073Oak2008
2163208.15600643900173Oak2009
34693314.212121150016015900330Oak2010
44583214.3125160018411400320Oak2011
55233216.3437521022109300311Was2012
64383114.129032110112220100310Was2013
73152612.11538590010212300260Was2014
83483011.6110011812000270Was2015
93453210.7812511009414100311Was2016
104643214.5150015814100300Was2017
1168611.3333333003260060Mil2018
122792610.7307697007413500260Was2018
13177199.3157893002412300172Mil2019
1449124.08333351006330048ChA2020
Mr. Sports

Gio Gonzalez

Starting Pitcher

Birthday: September 19, 1985   Age: 38
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2008 Oak 54 10 5.40 1 0 0 8 36 0 0
2009 Oak 163 20 8.15 6 0 0 64 39 0 0
2010 Oak 469 33 14.21 15 0 0 160 159 0 0
2011 Oak 458 32 14.31 16 0 0 184 114 0 0
2012 Was 523 32 16.34 21 0 2 210 93 0 0
2013 Was 438 31 14.13 11 0 1 122 201 0 0
2014 Was 315 26 12.12 9 0 0 102 123 0 0
2015 Was 348 30 11.60 11 0 0 118 120 0 0
2016 Was 345 32 10.78 11 0 0 94 141 0 0
2017 Was 464 32 14.50 15 0 0 158 141 0 0
2018 Was-Mil 68 6 11.33 3 0 0 32 6 0 0
2018 Was-Mil 279 26 10.73 7 0 0 74 135 0 0
2019 Mil 177 19 9.32 3 0 0 24 123 0 0
2020 ChA 49 12 4.08 1 0 0 6 33 0 0