Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 7.1 ms
Record Count: 7
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 = '11116'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
1110912.22222220024660090Ari2019
263610.510014390060Mia2019
31691214.0833333003410500120Ari2020
4219239.5217394084213200230Ari2021
54453014.833333120013019500300Ari2022
64643413.647058517011909900340Ari2023
774612.33333330032120060Ari2024
Mr. Sports

Zac Gallen

Starting Pitcher
Arizona Diamondbacks
Birthday: August 03, 1995   Age: 28
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2019 Mia-Ari 110 9 12.22 2 0 0 24 66 0 0
2019 Mia-Ari 63 6 10.50 1 0 0 14 39 0 0
2020 Ari 169 12 14.08 3 0 0 34 105 0 0
2021 Ari 219 23 9.52 4 0 8 42 132 0 0
2022 Ari 445 30 14.83 12 0 0 130 195 0 0
2023 Ari 464 34 13.65 17 0 1 190 99 0 0
2024 Ari 74 6 12.33 3 0 0 32 12 0 0