Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 8.33 ms
Record Count: 16
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 = '8955'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
199128.25100147500120Fla2011
2010000000010Mia2012
33365.51002210015Mia2013
4192316.1935483114210500229Mia2014
5184374.97297340042102001720Mia2015
662321.937510044800320Mia2016
7120462.6086957310872002719SD2016
8403725.5972223321040123002646SD2017
9128274.740741080123600027Cle2018
10333427.9285712240462700141SD2018
11498608.36340683000060Cle2019
12220239.565217216034600023Cle2020
13382685.6176476210466600068Phi2021
14161552.9272728350126900055Phi2022
1559202.9521022700119Atl2023
1675391.923076920045100039Col2023
Mr. Sports

Brad Hand

Relief Pitcher
Free Agent
Birthday: March 20, 1990   Age: 34
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2011 Fla 99 12 8.25 1 0 0 14 75 0 0
2012 Mia 0 1 0.00 0 0 0 0 0 0 0
2013 Mia 33 6 5.50 1 0 0 2 21 0 0
2014 Mia 192 31 6.19 3 1 1 42 105 0 0
2015 Mia 184 37 4.97 4 0 0 42 102 0 0
2016 Mia-SD 62 32 1.94 1 0 0 4 48 0 0
2016 Mia-SD 120 46 2.61 3 1 0 8 72 0 0
2017 SD 403 72 5.60 3 21 0 40 123 0 0
2018 SD-Cle 128 27 4.74 0 8 0 12 36 0 0
2018 SD-Cle 333 42 7.93 2 24 0 46 27 0 0
2019 Cle 498 60 8.30 6 34 0 68 30 0 0
2020 Cle 220 23 9.57 2 16 0 34 6 0 0
2021 Phi 382 68 5.62 6 21 0 46 66 0 0
2022 Phi 161 55 2.93 3 5 0 12 69 0 0
2023 Col-Atl 59 20 2.95 2 1 0 2 27 0 0
2023 Col-Atl 75 39 1.92 2 0 0 4 51 0 0