Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 8.04 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 = '11470'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
1942.25000090031KC2020
2204248.56085490001113KC2021
351261.961538400005100719KC2022
4197672.9402986140614100463KC2023
Mr. Sports

Carlos Hernández

Relief Pitcher
Kansas City Royals
Birthday: March 11, 1997   Age: 27
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2020 KC 9 4 2.25 0 0 0 0 9 0 0
2021 KC 204 24 8.50 6 0 8 54 90 0 0
2022 KC 51 26 1.96 0 0 0 0 51 0 0
2023 KC 197 67 2.94 1 4 0 6 141 0 0