Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 11.9 ms
Record Count: 4
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 = '11536'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
1139294.793103530144500029SF2021
2456686.70588256270606600068SF2022
3542687.9705886380723000068SF2023
4101147.21428626012900014SF 2024
Mr. Sports

Camilo Doval

Relief Pitcher
San Francisco Giants
Birthday: July 04, 1997   Age: 26
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2021 SF 139 29 4.79 5 3 0 14 45 0 0
2022 SF 456 68 6.71 6 27 0 60 66 0 0
2023 SF 542 68 7.97 6 38 0 72 30 0 0
2024 SF 101 14 7.21 2 6 0 12 9 0 0