Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 8.57 ms
Record Count: 5
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 = '10926'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
1623000060011NYA2020
2623000060011NYA2021
3168286520326600325NYA2022
4292329.1259005215000311NYA2023
582711.71428630016360070NYA2024
Mr. Sports

Clarke Schmidt

Starting Pitcher
New York Yankees
Birthday: February 20, 1996   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
2020 NYA 6 2 3.00 0 0 0 0 6 0 0
2021 NYA 6 2 3.00 0 0 0 0 6 0 0
2022 NYA 168 28 6.00 5 2 0 32 66 0 0
2023 NYA 292 32 9.13 9 0 0 52 150 0 0
2024 NYA 82 7 11.71 3 0 0 16 36 0 0