Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 6.74 ms
Record Count: 8
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 = '10402'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
13348.251008150031Col2016
23262911.2413811009012600290Col2017
34253312.878788140114414100330Col2018
43492812.464286120211011400280Col2019
51711313.153846400448700130Col2020
63933212.281251201413412900320Col2021
73133110.0967749008813500310Col2022
83749.252001430040Col2023
Mr. Sports

Germán Márquez

Starting Pitcher
Colorado Rockies
Birthday: February 22, 1995   Age: 29
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2016 Col 33 4 8.25 1 0 0 8 15 0 0
2017 Col 326 29 11.24 11 0 0 90 126 0 0
2018 Col 425 33 12.88 14 0 1 144 141 0 0
2019 Col 349 28 12.46 12 0 2 110 114 0 0
2020 Col 171 13 13.15 4 0 0 44 87 0 0
2021 Col 393 32 12.28 12 0 14 134 129 0 0
2022 Col 313 31 10.10 9 0 0 88 135 0 0
2023 Col 37 4 9.25 2 0 0 14 3 0 0