Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 21.5 ms
Record Count: 6
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 = '11083'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
181184.5000000000Oak2007
2623000000000Oak2008
31872.57142850000180070Det2020
4297309.97067415300300Det2021
512260000120020Det2022
65569.16666710012330060Det2024
Mr. Sports

Casey Mize

Starting Pitcher
Detroit Tigers
Birthday: May 01, 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
2007 Oak 81 18 4.50 0 0 0 0 0 0 0
2008 Oak 6 2 3.00 0 0 0 0 0 0 0
2020 Det 18 7 2.57 0 0 0 0 18 0 0
2021 Det 297 30 9.90 7 0 6 74 153 0 0
2022 Det 12 2 6.00 0 0 0 0 12 0 0
2024 Det 55 6 9.17 1 0 0 12 33 0 0